srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,860
- Office Version
- 365
- Platform
- Windows
I need an sumproduct(Indirect formula that will see the headings of columns (month) and go to that sheet and sum all values from a column, a column D, if it meets two criteria of column A and column B.
so for example on sheet one where the formula is,
I want to add up all the hours of technicians who worked on "PROJECT" (Column A Heading), WIND, and they worked on "WARRANTY", (column B) in the month of 'AUGUST", (first heading of columns C through N, 12 months).
Thanks
so for example on sheet one where the formula is,
I want to add up all the hours of technicians who worked on "PROJECT" (Column A Heading), WIND, and they worked on "WARRANTY", (column B) in the month of 'AUGUST", (first heading of columns C through N, 12 months).
Thanks