IF function

[Dejan]]

Hello,
I'm from Macedonia, we have to values for VAT, 18% and 5%. I try to separate values that have 18% VAT and 5% VAT. I'm using IF function but not is that I need
I'd like to SUM all cell from H2 to H24 that have 18% VAT in H27 and in G27 I'd like to SUM all cells that have 5% from H2 to H24

[NBVC]

Try using SUMIF

e.g

=SUMIF(I2:I24,5,H2:H25) or =SUMIF(I2:I24;5;H2:H25)

and

=SUMIF(I2:I24,18,H2:H25) or =SUMIF(I2:I24;18;H2:H25)

[Dejan]]

Thanks it's work

[NBVC]

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save