Additional criterion date function to be added to existing formula

I am looking to replicate the same formula in Cell V3 of the RESULT DATA sheet in cell W3 with additional criteria.
The outcome is to be based on the dates shown in GOIT907! Column D that is less than or equal to the date displayed in “GOIT907!$P$2.”
The formula is already looking at the GOIT907 sheet, for any fund with P (column F) with a blank in the result (column G) then adding the hours from Column O.
By my manual calculation, the result should be 23,260.
Any help please???

Hi Christopher,

You can use the below formula in W3:-

{=SUM(IF((GOIT907!$D$2:$D$5000<=GOIT907!$P$2)*(GOIT907!$F$2:$F$5000=$A$3)*(GOIT907!$G$2:$G$5000=V$1),GOIT907!$O$2:$O$5000,""))}

Above is an array formula and need to be entered using CTRL SHIFT ENTER key combination. thanks.

Sample file
Test Excel Forum 24 April.xlsm


Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome..

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>