SUMIF not returning the correct value?

Question

Here is the formula I wrote and what it is returning. It returns 3 and I was expecting 9 and I'm not sure what is wrong. Any help would be appreciated.

Answer 1

SUMIF only works with the one column to Sum. there are several work arounds which you can view at the following link. Note it is not a Microsoft site so take care if clicking any advertising links.

https://www.ablebits.com/office-addins-blog/excel-sumif-miltiple-columns/

Answer 2

Re: use of SumIf formula

This works =SUMIF(A5:C9,"ado2",D5:F9) if the data range is...

Note the criteria range is the same size as the sum range.

This works using an array formula on your original data...

{=SUM(IF(A5:A9="ado2",B5:D9,"n/a"))}

'---
Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Answer 3

Thanks Ossie.

I should have looked more carefully at the MS Excel help examples. This was bothering me so thanks so much for the help! Gerry.