Multiple sheets, multiple criteria formula excel 365 and Google sheets

[N0t Y0urs]

So after many hours and lots of assistance I am nearly there.

What I would like now is the following, this is my current formula:

=SUMIFS(Group1!$N$3:$N,Group1!$D$3:$D,"<="&$B$14)

I would like to add to this formula is 3 more criteria.

That formula is in H14 and I would like to add H13 needs to equal Group1!N2, B14 needs to equal Group1!P2 and B13 needs to equal Group1!$1:$1

So to explain this without the sheet. Group1$1:$1 identifies a group that’s between 1 and 10. Group 1 data will have identifies of 1 and 2

B14 needs to equal the unique number at Group1!$2:$2.

So there are 5 sheets of data being Group1-5, row 1 has 10 x 1, 10 x 2 … to 10 x 10
Row 2 has column titles and each sheet has the numbers between 1 and 100 which equal the b column.

Can I add to my formula to assist in my data reporting or do I have to do things the long way and do calculations first and then use my existing formulas to report the information

Could I use lookups to help filter?