SUMIF function- URGENT

[sangeeta25]

Hi

I have the below function

=SUMIF(D8:D38, "Client sales**", C8:C38)

However I would also like to include "trader related" as in SUMIF applies if D8:D38 reads "Client sales**" OR if it reads "trader related"

Can anyone help?

Thanks in advance

S

 

[JackDanIce]

See if this link helps:
Excel SUMPRODUCT Formula - Syntax, Usage, Examples And Tutorial | Chandoo.org - Learn Microsoft Excel Online

 

[steve the fish]

Maybe this:

=SUM(SUMIF(D8:D38,{"Client sales*","trader related"},C8:C38))

 

[sangeeta25]

Perfect!!!!
Thank you!