Posted to microsoft.public.excel.programming
|
|
SUMIF Question
That does the trick - many thanks
--
Cheers
Nigel
"William" wrote in message
...
Hi Nigel
Try...
=SUMIF(A1:A5,"<"&"",B1:B5)
--
XL2003
Regards
William
"Nigel" wrote in message
...
Hi All
I use the SUMIF worksheet function to SUM a range conditionally, eg
SUMIF(A1:A5,"",B1:B5), which works great for summing B1:B5 if any cell
in
A1:A5 is blank
I now wish to reverse the logic and sum if any cell in A1:A5 are NOT
blank,
but
SUMIF(A:A5,NOT(""),B1:B5) does not work !
Please help
--
Cheers
Nigel
|