M Mosqui May 8, 2009 #1 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
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 T. Valko May 8, 2009 #2 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))
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))
M Mosqui May 8, 2009 #3 That was just perfect. Many Thanks T. Valko said: 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)) Click to expand...
That was just perfect. Many Thanks T. Valko said: 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)) Click to expand...
