Hello,
I have a simple sumif formula and I noticed it's not adding up properly. In some cases, it's only adding up the first instance it sees a criteria.
=SUMIF($F$16:$F$66,K16,$H$16:$I$66)
K16 for example has 1 in it. F16 to F66 has 1 a few times and , 2s, 3s e.t.c.
But the formula is only adding up the 1st 1. I have checked if have formated columns H to I as currency and so they are not in text.
any ideas?
Thank you.
Bookmarks