Sumproduct help

[Mosqui]

I want to count how many valves I have with fw1, so two conditions.

fw1 valve
fw1 pin
fw1 pin
fw2 valve
fw2 pin

Thanks
Mosqui

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A1:A5="fw1"),--(B1:B5="valve"))

Better to use cells to hold the criteria:

D1 = fw1
E1 = valve

=SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1))

 

[Mosqui]

That was just perfect.

Many Thanks

Try this:

=SUMPRODUCT(--(A1:A5="fw1"),--(B1:B5="valve"))

Better to use cells to hold the criteria:

D1 = fw1
E1 = valve

=SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1))

 

[T. Valko]

You're welcome. Thanks for the feedback!