Not really sure where to start with this one. I have a forumula,
=SUMPRODUCT(--(MOD(COLUMN(F9:CT9),3)=0),F9:CT9). I need to incorporate
a MATCH function so that it matches the date in row f3. Similar to
=IF(Date=0,"",OFFSET($E$5:$E$103,,MATCH(Date,$F$3: $CX$3,0))).
Ultimately, I need the formula to sum every third column, based on the
date in the range F3:CX3, and then multiply each column whose date is a
weekday (Mon-Thu) by 1.13 and weekend (Fri-Sun) by 1.23
Thanks in advance.
EP
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread:
http://www.excelforum.com/showthread...hreadid=539707