Any body pls help...... Sheet1 Date/Week/Month/Category/Amount spend 1/1/Jan/Food/100 1/1/Jan/Travell/50 1/1/Jan/Fuel/200 2/2/Jan/...... 2/2/Jan/...... Sheet2 Column-A/Column-B Week/Total spend 1/350 2/300 3/... 4/... etc Is there any formula to add all the week-1 expenditure in Sheet1 and show in Sheet2 (Column-B)
Look in the help index for SUMIF. Does your example add up? -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com
In Sheet2 with cell A2 having weeknumber try this formula in cell B2 =sumif(Sheet1!B:B,A2,Sheet2!E:E) If this post helps click Yes --------------- Jacob Skaria