Excel spreadsheet IF

Copper Contributor

Hi I wonder if someone can point me in the right direction, please 

 

I want to add a value of a cell to the sum of another value in another cell if a condition is met. 

 

For example

 

Amount Out:  Expense Type:   VAT:

£10.00.            Fuel                   S

10.00.              Ice cream          N 

15.00.              Fuel.                  N

 

 

S VAT: £10

N VAT: £20

 

Fuel: £20

Ice Cream £10

 

 

So when a value is added EG N or S VAT the value is added to the sum in the VAT S or N cell, and if an expense type is added it's added to the expense type area with the sum of the expense type. 

I hope this makes sense. 

3 Replies

@jamesdavidknight if I understand the request properly you could use the SUMIF function in excel:

 

say I have

column A holds the amount

column B holds the type

column C holds the VAT code

 

cell D1 holds S and D2 is where I will hold the S sum

cell E1 holds N and E2 is where I will hold the N sum

 

So for S:

SUMIF(C:C, D1, A:A)

… to add if you have multiple conditions use the SUMIFS there are also COUNTIF equivalents
N Vat: should be 25, also Fuel should sum 25 (10+15)?