I am trying to find the sum of 4 columns based on two different criteria. I have the formula for two columns but when I try to include two other columns it doesn't work.
Is this anything that someone can help me with. I want to include two more columns to the formula.
=SUM(IF('Entry Sheet'!$E$18:$E$517='Entry Sheet'!W52,IF('Entry Sheet'!$F$18:$F$517=$N$9,IF('Entry Sheet'!$M$18:$M$517>0,'Entry Sheet'!$M$18:$M$517),0),0),0
Bookmarks