B
BenJAMMIN
Here is a formula that I am using. It is setup to draw information from different workbooks.
=+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Mahdi.xls]July # of Obs'!C15:L15))+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Lovato.xls]July # of Obs'!C15:L15))+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[LaJeunesse.xls]July # of Obs'!C15:L15))+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Feekin.xls]July # of Obs'!C15:L15))
Currently where it has cells C15:L15 I need to have it add the following cells:
C17, C20, C23, C26, C29
F17, F20, F23, F26, F29
I17, I20, I23, I26, I29
L17, L20, L23, L26, L29
It is late in the day & I have been working formulas all day. I am sure it is a simple solution to add these cells but.............
=+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Mahdi.xls]July # of Obs'!C15:L15))+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Lovato.xls]July # of Obs'!C15:L15))+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[LaJeunesse.xls]July # of Obs'!C15:L15))+SUMPRODUCT(--('\\ntphg001v2\common_b\QA_Team_Specialists\Dale''s_Team_B_&_C\[Feekin.xls]July # of Obs'!C15:L15))
Currently where it has cells C15:L15 I need to have it add the following cells:
C17, C20, C23, C26, C29
F17, F20, F23, F26, F29
I17, I20, I23, I26, I29
L17, L20, L23, L26, L29
It is late in the day & I have been working formulas all day. I am sure it is a simple solution to add these cells but.............