Sum cells if another cell is blank and another cell says something specific

[Alenz]

It feels that my formula should not be too complicated but I just can't get it to work. Teaching myself Excel here, yipes!

If CW16:EA16 is blank and CW7:EA7 is "Sunday", I need it to sum the amounts in CW17:EA17. Otherwise it should just say "0".

The following part is good but I need it to also look at CW16:EA16:
=IF(A11<>"",SUMIFS(CW11:EA11,$CW$7:$EA$7,"Sunday"),"")

I have tried the below that do not work:
1. =IF(CW16:EA16<>"","0",(IF(A17<>"",SUMIFS(CW17:EA17,$CW$7:$EA$7,"Sunday"),"0")))
2. =IF(ISBLANK(CW16:EA16),(IF(A17<>"",SUMIFS(CW17:EA17,$CW$7:$EA$7,"Sunday"),"")),"0")

The above point 2 keeps returning "value"! whether or not there are amounts in and weather or not CW16:EA16 is blank or contains values.

 

[AliGW]

Does this work for you?

=IFERROR(IF(A11<>"",SUMIFS(CW11:EA11,$CW$7:$EA$7,"Sunday"),""),"")

 

[Tetra201]

Is this what you need?

=IF(A17<>"",IF(COUNTIF(CW16:EA16,"")=COLUMNS(CW16:EA16),SUMIFS(CW17:EA17,$CW$7:$EA$7,"Sunday"),0),"")