countif function

[Guest]

Not sure if this is possible but I need to count the number of items from two
columns based on certain criteria.

i.e.

25% SL I
25% SL II
50% SL I
etc

I need to count all SLx at 25% or 50% etc.

Is this possible?

Thanks

 

[Guest]

I should have looked further down the list first of all. I notice someone
else wanted the same thing and it is solved using the SUMPRODUCT function.

 

[Guest]

I should have looked further down the list first of all. I notice someone
else wanted the same thing and it is solved using the SUMPRODUCT function.