Hi, do you mean counting the "Yes" per code?
Maybe in M2
=SUMPRODUCT(($B$2:$B$12=K2)*($C$2:$I$12="Yes"))
Hope it helps
Regards
-----------------
Sorry: I did not mean to overlap.
Hi, do you mean counting the "Yes" per code?
Maybe in M2
=SUMPRODUCT(($B$2:$B$12=K2)*($C$2:$I$12="Yes"))
Hope it helps
Regards
-----------------
Sorry: I did not mean to overlap.
Last edited by canapone; 02-09-2011 at 04:26 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks