Occasional Visitor

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