Add values of multiple cells dependant on the

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

Can anyone help me on a formula???

I need to add the total value of individual cells (put in C) in a colum of cells (B) dependant on what is written in the ajoining cell (A) eg

Item Spend Total Spend
food £12.00 £- food
kitchen £52.00 £- kitchen
garden £42.00 £- garden
exterior £18.00 £- exterior
food £35.00 £- car
kitchen £81.00
exterior £53.00
car £46.00
food £62.00
car £38.00
garden £41.00

NB. Call Item colum A, Spend colum B and Total Spend colum C

My goal is to know for example I spent £12 + £35 + £62 on food

Hope you can help

Thanks

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
use VLOOKUP(lookup_value,table_array,col_index_num,false)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!