SUMIF and multiple columns

W

wait3264

I need to add the number entries in three different columns. Must I use three
separate SUMIF functions and add them together? To get the total for all
three? Thanks, Kay
 
R

robert111

I suppose you could highlight the range of cells in each column together
and then name it as a non contiguos range, but I have never tried it....
 
B

Bob Phillips

Nice idea, but doesn't work.

Try this instead

=SUMPRODUCT(SUMIF(INDIRECT({"B1:B10","D1:D10","E1:e10"}),">10"))

as an example

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

robert111

thanks Bob, I learn something useful from this forum nearly every day.

Robert111 = another Bo
 
Top