|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
SUMPRODUCT
http://www.microsoft.com/office/comm...a-8d398339035a
--
** John C **
"Scott Kieta" wrote:
I tried submitting this before but i am not sure if it made it to the site, i
apologize if this is a duplicate.
Scenario: Worksheet with month data Nov 1- Nov 30 (F21:BU21) Row 22 is the
day format of those dates. Row 23 is alternating columns for attendance
headers "Reg, "OT") all the way through BU23.
G H
1-nov (Merged)
SAT (Merged)
Reg OT (sep columns)
Trying to sum all "reg" hours to one summary column, and all "OT" hours to
another column where any days Sat or Sun automatically sum to the OT hours.
And do not sum with the Reg hours.
This is my formula to start (which obvioulsy is not working) can someone
help point me in the right direction?
=SUMPRODUCT(F21:BU21=$F$21)*(F22:BW22=$G$22)*(--F23:BW24)
$F$21 represents cell indicating "Sat", $g$22 represents "OT"
I think i am overthinking it and just confusing myself
|