Add values of multiple cells dependant on the [Closed]

Question

Add values of multiple cells dependant on the [Closed]

Report

Will - Sep 2, 2009 at 07:25 AM
Excelguru

Posts: 261
Registration date: Saturday April 11, 2009
Status: Member
Last seen: June 21, 2011

- Sep 3, 2009 at 03:06 AM

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

Add values of multiple cells dependant on the
Changing values in one cell depending on drop down list values in another cell ✓ - Forum - Excel
If multiple cells contain value then add value ✓ - Forum - Excel
Add value to one cell if multiple other cells have any value ✓ - Forum - Excel
Add up the values of duplicate cells ✓ - Forum - Excel
Is there a way to call out multiple values in single cell? ✓ - Forum - Excel

1 reply

Ask a question

Excelguru · Accepted Answer · 2009-09-03T03:06:23-0400

Answer 1 / 1

Excelguru

Posts: 261
Registration date: Saturday April 11, 2009
Status: Member
Last seen: June 21, 2011

307
Sep 3, 2009 at 03:06 AM

use VLOOKUP(lookup_value,table_array,col_index_num,false)

Add values of multiple cells dependant on the [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!