I have it thanks both.
=SUM(IF(FREQUENCY(IF(B3:B11>0,IF(A3:A11="",0,A3:A11)),A3:A11),1))
Cheers
I have it thanks both.
=SUM(IF(FREQUENCY(IF(B3:B11>0,IF(A3:A11="",0,A3:A11)),A3:A11),1))
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks