# Sumif (Can this multiplr or be done withouth keep using + and the sumif formula again

#### mahmed1

##### Well-known Member
Hi Guys, Can this multiple or be done a better way?

=SUMIFS(Table1[Time (Hrs)],Table1[exception],Sheet1!\$F4,Table1[Manager],\$L\$1)+SUMIFS(Table1[Time (Hrs)],Table1[exception],Sheet1!\$F4,Table1[Manager],\$L\$2)+SUMIFS(Table1[Time (Hrs)],Table1[exception],Sheet1!\$F4,Table1[Manager],\$L\$3)

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### steve the fish

##### Well-known Member
You could do that by creating a named range L1:L3. Call it 'crit'. Then:

=SUMPRODUCT(SUMIFS(Table1[Time (Hrs)],Table1[exception],Sheet1!\$F4,Table1[Manager],crit))

Replies
3
Views
879
Replies
14
Views
559
Replies
3
Views
249
Replies
3
Views
1K
Replies
3
Views
2K

1,190,579
Messages
5,981,757
Members
439,733
Latest member
Ahmed8054

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back