SUMPRODUCT(--(MOD(COLUMN Multiple Sheets

[ozbeachbum]

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.

 

[Special-K99]

Since the sheet name in COLUMN() is irrelevent, wouldn't this just be

='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)
+SUMPRODUCT(--(MOD(COLUMN(AX59:GN59)-COLUMN(AX59)+1,42)=0),'COM BID Off Pur'!AX59:GN59)
+SUMPRODUCT(--(MOD(COLUMN(AZ59:GN59)-COLUMN(AZ59)+1,42)=0),'COM BID Off Pur'!AZ59:GN59)

 

[ozbeachbum]

Thank you so much, really appreciated.
Works perfectly.