ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 233
- Office Version
- 2021
- Platform
- Windows
Hi all,
I have the following formula that works perfectly, but I wish to add another sheet to it and have had no success with my efforts.
Any suggestions or information greatly appreciated.
='Monies Draw Down'!K4
+SUMPRODUCT(--(MOD(COLUMN(AX59:GN59)-COLUMN(AX59)+1,42)=0),AX59:GN59)
+SUMPRODUCT(--(MOD(COLUMN(AZ59:GN59)-COLUMN(AZ59)+1,42)=0),AZ59:GN59)
The above formula is on sheet: HOLD CUR Off Acq Pur Sel
The sheet I wish to ADD is named: COM BID Off Pur, and the reference would be a carbon copy of the two SUMPRODUCTs shown above.
Cheers.
I have the following formula that works perfectly, but I wish to add another sheet to it and have had no success with my efforts.
Any suggestions or information greatly appreciated.
='Monies Draw Down'!K4
+SUMPRODUCT(--(MOD(COLUMN(AX59:GN59)-COLUMN(AX59)+1,42)=0),AX59:GN59)
+SUMPRODUCT(--(MOD(COLUMN(AZ59:GN59)-COLUMN(AZ59)+1,42)=0),AZ59:GN59)
The above formula is on sheet: HOLD CUR Off Acq Pur Sel
The sheet I wish to ADD is named: COM BID Off Pur, and the reference would be a carbon copy of the two SUMPRODUCTs shown above.
Cheers.