Update on multiple query formula please

[Christopherdj]

I require an additional Data/Formula in Cell Y3 of the attached Result Data Sheet please.

The criteria is the same as the array formula in Cell X3 with the following variation and addition:
Date is to be greater than which I have changed to ">" already,

But I also need additional criteria to include Cell Reference $B$2. That is, it will be looking for any entries with an ST beyond the date shown in P2 of the GOIT907 report. When this is done - (another formula, sorry) -

Is it also possible to include the same formula shown at Cells X3 and Y3 but also adding the GOIT907!$K$2:$K$10000="SR" criteria in Cell Reference X21 and Y 21 respectively? (Based on the same criteria in X3 and Y3 but with the additionsl query.)

Seems like a big ask, and I thank anyone in advance who can amend this for me.

Regards - Chris

[Cutter]

First of all, I would recommend that you use SUMIFS() instead of your current array formulae. Your profile indicates Excel 2003 but your file is Excel 2007+ so SUMIFS() is available to you.
So, in X3 (and copied down) you could use:
=SUMIFS(GOIT907!$O:$O,GOIT907!$D:$D,"<="&$X$2,GOIT907!$F:$F,$A3,GOIT907!$G:$G,W$1&"")
(I have used whole columns for sake of clarity - you can use actual ranges if you wish)
Then, in Y3 (and copied down) this:
=SUMIFS(GOIT907!$O:$O,GOIT907!$D:$D,">"&$Y$2,GOIT907!$F:$F,$A3,GOIT907!$G:$G,W$1&"")

Your new formulas to add the SR criteria would simply be:
=SUMIFS(GOIT907!$O:$O,GOIT907!$D:$D,"<="&$X$2,GOIT907!$F:$F,$A3,GOIT907!$G:$G,W$1&"",GOIT907!$K:$K,"SR")
and
=SUMIFS(GOIT907!$O:$O,GOIT907!$D:$D,">"&$Y$2,GOIT907!$F:$F,$A3,GOIT907!$G:$G,W$1&"",GOIT907!$K:$K,"SR")

[Christopherdj]

Thank you - I have amended my profile (work has upgraded recently). Formulas seem to be working ok. Thank you so much.

[Cutter]

You're welcome. Thanks for the 'star tap'.