countif function
 

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
--
Steve R

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.
--
Steve R


"Steve" wrote:

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
--
Steve R

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.
--
Steve R


"Steve" wrote:

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
--
Steve R