Sum array formula with multiple conditions

colinheslop1984

Board Regular
Joined
Oct 14, 2016
Messages
109
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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,567
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.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,095,680
Messages
5,445,929
Members
405,370
Latest member
Miguel_Rojas

This Week's Hot Topics

Top