Counting multiple values (including blanks) in one column
On Mar 9, 2:34 am, "Max" wrote:
.. It still does not count blanks in column C
This part in the expression should have taken care of it:
..+(C2:C10="")..
Perhaps there are white space(s) in the cells,
these cells might appear "blank" but are not really so.
Try wrapping a TRIM around the range, viz try:
=SUMPRODUCT((A2:A10="Fred")*(B2:B10<"bob")*((C2:C 10="AA")+(TRIM(C2:C10)="")))
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
Max
you are a champion. I used the following and it works a treat
=SUMPRODUCT(('Grid data'!B9:B4563=A9)*(ISERROR(SEARCH("bob*",'Grid
data'!D9:D4563))*(('Grid data'!F9:F4563="aa")+(TRIM('Grid data'!
F9:F4563)=""))))
Thanks very much Max
Paul
|