SumIf with an Or
Hi Karen,
This might help you:
=SUM(IF(A10=61505,B9:B11,IF(A10=61515,B9:B11,IF(A1 0=61517,B9:B11))))
This is an array function
Thanks
Shail
KarenH wrote:
I have a SUMIF statement that doesn't appear to be working -- not throwing an
error, but not returning the correct value:
=SUMIF(DataSheet!$C:$C,"61505 OR 61515 OR 61517",DataSheet!$E:$E)
What I'm trying to say is that if the value in column C is 61505 or 61515 or
61517, then it should sum the values in column E. I have not used a range
for C or E, just the columns, because the number of rows will change
Googling on this tells me that it's probably not possible with a SumIf --
and I tried SumProduct, but that didn't work either.
Suggestions? Thanks in advance.
|