Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |