Thread
:
Group Total
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett