SUMIFS - an either or OR formula

[ExceLLemon]

Hello All, THANKs in Advance...trying to figure out if I can use the SUMIFS function to sum the following,

I want to Sum the Total of a criteria if the CELL-X has a DATE that passed the CELL-A(a specific Date) And/OR if the CELL-X is blank.

My current formulas are as follows...don't know how to combine them

=SUMIFS(L3:L39,F3:F39,A43,$N$3:$N39,"") < refers to Sum if Blank
=SUMIFS($L$3:$L$39,$F$3:$F$39,$A43,$N$3:$N$39,">"&$A$1) < refers to Sum if Date is greater than A1

THANKS!!!!!

[daddylonglegs]

Try this version

=SUMPRODUCT(SUMIFS(L3:L39,F3:F39,A43,$N$3:$N39,CHOOSE({1,2},"",">"&$A$1)))

[ExceLLemon]

THANK YOU so very much it works!!!!!

Just wondering if I need to combine SUMIFs, do I always have to use sumproducts!!!

Have a great week!

[daddylonglegs]

In this case because you have two criteria for the last condition the formula returns an array of two values - I used SUMPRODUCT to sum those two values (because SUMPRODUCT doesn't normally need "array entry"). If you want you can use SUM instead of SUMPRODUCT but then the formula needs to be confirmed with CTRL+SHIFT+ENTER

[ExceLLemon]

Thanks so much, got so much to learn...