MrExcel.com - Your One Stop for Excel Tips & Solutions

Array Formula

Posted by Dan on October 28, 2001 4:28 PM

How can I get a conditional sum array formula to return a text message if none of the criteria are met.
{=sum(if((criteria)*(criteria),range to sum," "))} returns 0.

Thanks

Posted by Carol on October 29, 2001 3:23 AM

{=IF(SUM(IF((criteria)*(criteria),range to sum))=0,"Text")}


Posted by Carol on October 29, 2001 3:27 AM


Oops, forget to add rest of formula...
{=IF(SUM(IF((criteria)*(criteria),range to sum))=0,"Text",SUM(IF((criteria)*(criteria),range to sum)))}