SUMIF and multiple columns
 

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

SUMIF and multiple columns
 

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....


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=570706

SUMIF and multiple columns
 

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)

"robert111" wrote
in message ...

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....


--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=570706

SUMIF and multiple columns
 

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

Robert111 = another Bob


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=570706