Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Total
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Total
Look in the help index for SUMIF. Does your example add up?
-- Don Guillett Microsoft MVP Excel SalesAid Software " VLOOKUP fORMULA" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Total
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 " VLOOKUP fORMULA" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running Total per group of items | Excel Worksheet Functions | |||
pick the greatest number out of a group for the total box | Excel Worksheet Functions | |||
Need to total how many came from a particular group. | Excel Discussion (Misc queries) | |||
Data Group Total | Excel Worksheet Functions | |||
Data Group Total | Excel Worksheet Functions |