Need help with SUMIF
 

I want the sum of 3 numbers if all of the 3 cells contain numbers if not
the value of the cell should be blank

=SUMIF(L2:N2,,L2:N2)
Range L2:N2 = {274.165," ", 35.057}
Criteria ???????
Sum_Range L2:N2

What would be the criteria to use to return a value or 0 or blank if
L2:N2 is blank


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=515991

Need help with SUMIF
 

=if(count(l2:n2)<3,"",sum(l2:n2))

Not really a =sumif() function.

nander wrote:

I want the sum of 3 numbers if all of the 3 cells contain numbers if not
the value of the cell should be blank

=SUMIF(L2:N2,,L2:N2)
Range L2:N2 = {274.165," ", 35.057}
Criteria ???????
Sum_Range L2:N2

What would be the criteria to use to return a value or 0 or blank if
L2:N2 is blank

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=515991

--

Dave Peterson

Need help with SUMIF
 

Try this.

=IF(COUNTA(L2:N2)<3,0,SUM(L2:N2))

HTH
Regards,
Howard

"nander" wrote in
message ...

I want the sum of 3 numbers if all of the 3 cells contain numbers if not
the value of the cell should be blank

=SUMIF(L2:N2,,L2:N2)
Range L2:N2 = {274.165," ", 35.057}
Criteria ???????
Sum_Range L2:N2

What would be the criteria to use to return a value or 0 or blank if
L2:N2 is blank


--
nander
------------------------------------------------------------------------
nander's Profile:
http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=515991

Need help with SUMIF
 

thanks, it works!!


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=515991