Smithsat34
Board Regular
- Joined
- Jan 20, 2014
- Messages
- 54
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
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