Sumif formula needs to split 2 criterias of addition

Hi there,

you guys very kindly helped me with a spreadsheet a couple of months ago, but i now need to adapt it for another dept. I have completed as much as I can.

I need column C and E in the 'totals tab' to only calculate contract and upgrade sales respectively (found in 'service orders' tab). I also need Scott's and ash's individual sales to be calculated in corrisponding tabs.

Most of the formulas are in place so just need them tweaked slightley.

Thanks

Sam

See attached...

Sam, re: Scott/Ash why not refer to your earlier post today where you were given Sumproduct's that do what you need - you're presently referencing incorrect columns and including the header row which is why you're generating errors in the first instance. No one minds helping (why we're here) but it's always good to see people trying to put into practice things discussed previously.

in c8
=SUMPRODUCT(--('Service Orders'!$B$2:$B$927=B8),--('Service Orders'!$I$2:$I$927="contract"),'Service Orders'!$F$2:$F$927)
in
e8
=SUMPRODUCT(--('Service Orders'!$B$2:$B$927=B8),--('Service Orders'!$I$2:$I$927="upgrade"),'Service Orders'!$F$2:$F$927)