LinkBack URL
About LinkBacks
JapanDave 
in C22: =SUMPRODUCT((B3:B20="Full")*(C3:C20={"a","b","c"}))
the result will be (10) different from the 11 that you have indicated in your sheet, since C11 is blank.
in C23: =SUMPRODUCT((B3:B20="Part")*(C3:C20={"a","b","c"}))
in C22: =SUMPRODUCT((B3:B20="Full")*(C3:C20={"a","b","c"}))
the result will be (10) different from the 11 that you have indicated in your sheet, since C11 is blank.
in C23: =SUMPRODUCT((B3:B20="Part")*(C3:C20={"a","b","c"}))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks