using Countif but also taking into account multiplier values

Hi,

I have been creating a spreadsheet to track samples.

I have been using a 'Data Validation' lists to ensure the data input can only match the desired data from a list.

I have then created a list of the various data input option and using a 'countif' to add up the number of each sample type being tested, however sometimes the data input has only one type of test but it is repeated multiple times.

So I need to know how can I 'countif' but also check that there is possible a multiple of the selected test and allow for a multiplication to take place. The majority of the data is only 1 test but on occasion the same test is repeated multiple times.

I have taken some screenshots but can't get them uploaded for some reason.

Regards

Rezarf

this shows the data to be counted.

lab book.png

This is the countif, but it does not calculate the multiple counts for 'BLANKS', 'CUT IN', CD117 etc..

lab book countif.png

Regards

Rezarf

I'm going to try it once I'm home as it doesn't seem to work while at work.

here is an extract from the spreadsheet all sensitive material removed.

Hope this helps

log book test.xlsx

Originally Posted by Ace_XL

In B31

=SUMPRODUCT(($B$2:$I$27=A31)*$A$2:$A$27)

Copy down

...........

Thank you so much, works perfect.

Rezarf