Thread: Group Total
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VLOOKUP fORMULA  VLOOKUP fORMULA is offline
external usenet poster
 
Posts: 32
Default 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)