Thread
:
sumproduct text if
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
sumproduct text if
Can SUMPRODUCT() return Text?
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Gary''s Student" wrote in message
...
=if(or((sumproduct()=""),(sumproduct()="text")),an othervalue,sumproduct())
--
Gary''s Student - gsnu200759
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann