=sumproduct((f5:f498=(cp5:cq5))*(e5:e498=(cp6:ct6) )*(m5:m498))

[Ruthki]

=SUMPRODUCT((F5:F498=(CP5:CQ5))*(E5:E498=(CP6:CT6))*(M5:M498)

I would like to use something like the above formula to sum totals in
lists depending on multiple criteria.

The forumla works for single criteria (eg where f5:f498=cp5) but will
not work for multiple criteria -ie the CP5 to CQ5.

Can anyone please help

Thanks

Ruthki
Cambridge, England

 

[Domenic]

Try...

=SUMPRODUCT(--(ISNUMBER(MATCH(F5:F498,CP5:CQ5,0))),--(ISNUMBER(MATCH(E5:E498,CP6:CT6,0))),M5:M498)

Hope this helps!

 

[Ruthki]

Thanks Domenic
It works just fine.

Ruthk