Sumif function? Two variables return error #VALUE

[Mrkumbo]

Hi everyone,

I am trying to automatize a staffing sheet where people fill in occupation by hour and position. Since it will likely cover multiple sites, I want to include a total at the bottom where people can switch between sites easily.

For some reason, I get a VALUE error when trying the sumif function with multiple variables (see cell F69 in attached doc).

The regular sumif function works fine but does not allow for a second variable.

Thanks for the help!

[JohnTopley]

Try

=SUMPRODUCT((DJ$8:DM$60)*($B$8:$B$60="Cook/Baker"))

[Pete_UK]

The ranges all have to be the same size for SUMIFS. Why not use SUMIF, as you only seem to have one criteria?

Hope this helps.

Pete

[Mrkumbo]

Sorry, wrong attachment was enclosed: I am trying to have 2 variables here (position in column B, site in column C).

Site is in cell B68, while positions are from B69 to B74.

[JohnTopley]

Try

=SUMPRODUCT((DJ$8:DM$60)*($B$8:$B$60="Cook/Baker")*($C$8:$C$60=$B$68))

[Mrkumbo]

Works like a charm, thanks!