If you're aiming to count the L-column "Yes" values which also have a corresponding F-column 0 value, this will do it:
![]()
=SUMPRODUCT(--(L4:L48="yes"),--(F4:F48=0))
If you're aiming to count the L-column "Yes" values which also have a corresponding F-column 0 value, this will do it:
![]()
=SUMPRODUCT(--(L4:L48="yes"),--(F4:F48=0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks