Hi
Its been commonly asked on here but the formulas I have tried don't seem to work.
I need a countif function to count values in column C (excluding duplicates) but only if cells in column I are blank.
Thanks
Don
Hi
Its been commonly asked on here but the formulas I have tried don't seem to work.
I need a countif function to count values in column C (excluding duplicates) but only if cells in column I are blank.
Thanks
Don
Post some sample data and tell us what results you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
As requested
Try this array formula**:
=SUM(IF(FREQUENCY(IF(I6:I12="",MATCH(C6:C12,C6:C12,0)),ROW(C6:C12)-ROW(C6)+1),1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
It says N/A
I have {=SUM(IF(FREQUENCY(IF(I6:I900="",MATCH(C6:C900,C6:C900,0)),ROW(C6:C900)-ROW(C6)+1),1))}
If there are empty cells in the column C range you'll get that error.
To account for empty cells try this version:
=SUM(IF(FREQUENCY(IF(I6:I900="",IF(C6:C900<>"",MATCH(C6:C900,C6:C900,0))),ROW(C6:C900)-ROW(C6)+1),1))
Still array entered.
That's great.
Thanks for that.
You're welcome. Thanks for the feedback!
No problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks