# Adding further criteria in SUMIFS formula (valid combination of two columns)

1. ## Adding further criteria in SUMIFS formula (valid combination of two columns)

Hi,

I have this formula

SUMIFS(X:X,U:U,A4,V:V,B4,W:W,">="&C4)

Basically, this formula is saying sum all the values in column X for where:

1). The values in column U = A4 AND
2). The values in column V = B4 AND
3). The values in column W greater than equal to C4.

Capture.JPG

The issue I have now is that I need to incorporate a further condition to this formula.
The condition is only execute this formula if:

Capture2.JPG

Does that make sense or it is not clear?

Thank You

2. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

It would help if you attached a sample Excel file, rather than a picture of one.

See the yellow banner at the top of the screen for details of how to do this.

Hope this helps.

Pete

3. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

Hi,

I have attached sample file.

Thanks

4. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

That file is password protected. I cannot open it.

5. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

Jazzer, the OP posted the pwd in post #3

6. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

Would that be =IF(and(B4="Sub",V4="Senior"),0,SUMIFS(X:X,U:U,A4,V:V,B4,W:W,">="&C4))

7. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

Originally Posted by Pepe Le Mokko
Jazzer, the OP posted the pwd in post #3

8. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

Thanks Pepe Le Mokko!!

9. ## Re: Adding further criteria in SUMIFS formula (valid combination of two columns)

You're welcome