Group Total

  • Thread starter RE: VLOOKUP fORMULA
  • Start date
R

RE: VLOOKUP fORMULA

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)
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top