Yeah SUMIF would be fine too. I didn't think much more than getting it working

I didn't *know* it straight away but simply removed all but the first criteria to see if that worked. Then I figured it must be an AND. I'm a programmer by trade so things like this make sense to me and so come to me fairly easily. I use various bits of Excel a lot but it's not my #1 tool by any means.

Also I did finally check at the help here:
https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b
says:


I wouldn't call that definitive - it could do with a "simultaneously" or "all" or similar in the initial description. The examples do mention meeting "both" conditions.

I do think an OR version would be useful in some cases (yours is clearly one) but there's obviously workarounds which don't increase complexity very much.