SumIF – 3 way lookup

[pauldaddyadams]

Hi,

I am trying to use SUMIF to sum a range based on three conditions.

I am trying to use formula to match the month, a total line and then a user dependent drop down list.

I only get an error but I don’t know why this would be, any ideas why?

The formulas should be in the yellow highlighted cells C52:N53

Paul