Forum Discussion
Excel spreadsheet IF
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 ...
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