# Sumif Formula using Cell content to refer to sheetname

#### Smithsat34

##### Board Regular
Board,

I have a three worksheets in a workbook, each one contains a months worth of data. They are titled Aug 16, Sep 16 & Oct 16.
I have a single summary sheet with a few sumif formulas. Ideally I want to be able to change a single cell on my summary sheet to reflect which month the sumif should look at. I have seen something like this elsewhere but just cannot find it.
Formula as follows:

summary sheet Cell C1 Sep 16

summary sheet Cell E4 =sumif('C1'!\$P:\$P,summary!a4,'C1'\$K:\$K)

Any suggestions to avoid 'find and replace' in the formula gratefully received

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### yky

##### Well-known Member
Try if the following formula works:

=SUMIF(INDIRECT("'" & \$C\$1 & "'!\$P:\$P"),A4,INDIRECT("'" & \$C\$1 & "'!\$K:\$K"))

Last edited:

#### Smithsat34

##### Board Regular
yky,

Thanks a million, for some reason I can't get INDIRECT to stick in my head,

Replies
4
Views
531
Replies
8
Views
3K
Replies
1
Views
575
Replies
9
Views
407
Replies
4
Views
250

1,191,308
Messages
5,985,904
Members
439,986
Latest member
DaveTee

### 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