LinkBack URL
About LinkBacks
With your above sample data in Range A2:D7 use this array formula
=SUM(IF(FREQUENCY(IF((D2:D7>0)*ISNUMBER(C2:C7),MATCH(A2:A7,A2:A7,0)),ROW(A2:A7)-ROW(A2)),1,0))
Confirm with Ctrl+Shift+Enter
With your above sample data in Range A2:D7 use this array formula
=SUM(IF(FREQUENCY(IF((D2:D7>0)*ISNUMBER(C2:C7),MATCH(A2:A7,A2:A7,0)),ROW(A2:A7)-ROW(A2)),1,0))
Confirm with Ctrl+Shift+Enter
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks