SUMIF over multiple columns

[Gwill1983]

Hi all,

Apologies if this is a duplicate post. I have read a few posts around this subject, but all are numerous years old and none of the suggestions have worked on my sheet so far!

I have a spreadsheet containing number of orders processed on a daily basis and I would like to add these up to show weekly totals so that I can use this data for a chart on another tab.

So... My sheet is set up as below:

Column A = Week Number
Column D = staff member A's number
Column E = staff member b's number
Column F = staff member c's number
Column G = staff member d's number


I would like to be to add the numbers in columns D,E,F & G if the week number in column A is 1.

I have tried all kind of SUMIF & SUMIFS but I just cannot make it work!

Any help will be much appreciated.

Thanks

Chris

 

[Marcelo Branco]

Maybe this array formula (adjust the ranges)

=SUM(IF(A2:A100=1,D2:G100))
confirmed with Ctrl+Shift+Enter, not just Enter

Hope this helps

M.