LinkBack URL
About LinkBacks
Hi
Assuming your data is in the range A1:B11 then try
=SUMPRODUCT(--(MID(A2:A11,6,1)="Z"),(B2:B11))
and
=SUMPRODUCT(--(MID(A2:A11,6,1)="B"),(B2:B11))
rylo
Hi
Assuming your data is in the range A1:B11 then try
=SUMPRODUCT(--(MID(A2:A11,6,1)="Z"),(B2:B11))
and
=SUMPRODUCT(--(MID(A2:A11,6,1)="B"),(B2:B11))
rylo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks