SUMPRODUCT, summing values

[bobtherocker]

I am using the following formula which looks at columns CE to CL for the word READING and returns the number of corresponding values in CV that are greater than the number 1.

=SUMPRODUCT(--($CE$6:$CL$45="READING")*(CV$117:CV$156>1))

What I need to do is SUM these values.

ie

if CE6=READING and CE8=READING
and CV117=2 and CV119=3

The formula should return the number 5. At present it returns the number 2.

 

[T. Valko]

I am using the following formula which looks at columns CE to CL for the word READING and returns the number of corresponding values in CV that are greater than the number 1.

=SUMPRODUCT(--($CE$6:$CL$45="READING")*(CV$117:CV$156>1))

What I need to do is SUM these values.

ie

if CE6=READING and CE8=READING
and CV117=2 and CV119=3

The formula should return the number 5. At present it returns the number 2.

Maybe this...

=SUMPRODUCT(($CE$6:$CL$45="READING")*(CV$117:CV$156>1)*CV$117:CV$156)

 

[barry houdini]

Cross-posted here