Hi

Try amending Max's formula to

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


--
Regards

Roger Govier


"oldLearner57" wrote in message
...
thanks Max, that really helps :)
and

is there possible for me to combined all the three formulae into 1 so
as I
can use these 3 formula as 1.. (if can, how do i do that??)
hope u understand what I am trying to say....?? :)

thanks again for the help very appreciated

thanks community as well
--
oldLearner57


"Max" wrote:

Oops, C1:C10 in the earlier sumproducts should have read as E1:E10,
ie

e.g 1 If Col B = "CHQ" & Col A = "" sum(E?:E?)
=SUMPRODUCT((B1:B10="CHQ")*(A1:A10=""),E1:E10)

e.g 2 If Col B = "CHQ" & Col A = "QCDM" sum(E?:E?)
=SUMPRODUCT((B1:B10="CHQ")*(A1:A10="QCDM"),E1:E10)

e.g 3 If Col B = "ADV" & Col A = "MER" sum(E?:E?)
=SUMPRODUCT((B1:B10="ADV")*(A1:A10="MER"),E1:E10)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---