Excel 2007 SUMIFS - why isn't this working?

[Participant]

Hi all

Please can you look at the below sample I've put toegther to try and teach myself this new formula, and tell me why it isn't chucking out 97? It's just giving me "0".

Many thanks.

 

[Participant]

Doh! Thanks all. Seems obvious now.

DSUM / pivots it is then.

FYI Malakite the formula was =SUMIFS(Q15:Q20,O15:O20,"C",P1520,"Cap").