Sum array formula with multiple conditions

[colinheslop1984]

I need to add an additional condition to this formula but not sure how to do it.

=SUM(IF(Womens!S$1:AE$1=$B25:$B25,IF(Womens!B$2:B$105=$O$1,Womens!S$2:AE$105)))

I also need to add in if Womens!a$2:a$105>=$g$1

I tried

=SUM(IF(Womens!S$1:AE$1=$B25:$B25,IF(Womens!B$2:B$105=$O$1,Womens!S$2:AE$105),if(Womens!a$2:a$105>=$g$1)))

but the result i am looking for was wrong

Any help would be great

 

[Eric W]

I'm a little unsure of your layout, but try:

=SUMPRODUCT((Womens!$S$1:$AE$1=$B25)*(Womens!$B$2:$B$105=$O$1)*(Womens!$A$2:$A$105>=$G$1)*(Womens!$S$2:$AE$105))


No CSE needed.