I need to add to a cell based on the specific answer in another cell

[mikerules]

I need a formula for E25 that returns:

If E14 has a value and F9=No then E25=$10.00 for each of cells C10, E10, G10, J10, M10, C11, E11, G11, J11, M11 that has an entry

if there was only an entry in C10 as an example and the other criteria was met the result would be 10.00
If there was an entry in all 10 of the cells then the result would be 100.00

Thanks,

Mike

[hemesh]

try below in E25
=IF(AND(E14<>"",F9="NO"),SUMPRODUCT(((C10:C11<>"")*10)+((E10:E11<>"")*10)+((G10:G11<>"")*10)+((J10:J11<>"")*10)+((M10:M11<>"")*10)),"Condition Not MET")
change the red part with what you want if condition doesn't meet.

Don't forget to keep the text inside " "