assume your criteria in Range A1:a6 and values to add in range b1:b6
then
=SUMPRODUCT(--(LEFT(A1:A6,13)="Anglo-Eastern"),B1:B6)
assume your criteria in Range A1:a6 and values to add in range b1:b6
then
=SUMPRODUCT(--(LEFT(A1:A6,13)="Anglo-Eastern"),B1:B6)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks