hi Max

10s again, now
I got all the 3 sumproduct formula and combined into 1 test
:)
very much appreciated :)

thanks community as well
:)
--
oldLearner57


"Max" wrote:

Roger, thanks for the help.
Thought it might be something like:
=SUMPRODUCT((B1:B10="CHQ")*(A1:A10={"","QCDM"})*E1 :E10)
+SUMPRODUCT((B1:B10="ADV")*(A1:A10="MER"),E1:E10)
since the OP's other value within B1:B10 is "ADV"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Govier" wrote in message
...
Hi

Try amending Max's formula to

=SUMPRODUCT((B1:B10="CHQ")*(A1:A10={"","QCDM","MER "})*E1:E10)


--
Regards

Roger Govier