Problems with IF statement when adding invoice values

**Darlo** · 01-26-2009, 09:27 AM

Can anyone advise me on my problem? I'm looking to add invoice values together from column H but only if the corresponding cells in column E state a certain Nominal code, for instance '4021'.

I'm guessing it's an 'IF' statement but can't seem to get it to work.

Any advice would be much appreciated.

Thanks in advance.

**Richard Schollar** · 01-26-2009, 09:36 AM

Hi

It's a SUMIF:

=SUMIF(E:E,4021,H:H)

Note that the criteria above can be a cell reference (eg A1) holding the criteria value. The formula cannot go into either column E or H as I have used whole column references (and this would create a circular reference) however you can limit the ranges to apply to eg by:

=SUMIF(E2:E100,4021,H2:H100)

Richard