Robert Bell, Good morning.
a) Change the "" to zero
Before:IF(A2<>"",25,"")+IF(A3<>"",25,"")+IF(A4<>"",25,"")
Now...:IF(A2<>"",25,
0)+IF(A3<>"",25,
0)+IF(A4<>"",25,
0)
b) Try to use another formula
=COUNT.IF(A2:A4,"<>")*25
Is this what you want?
I hope it helps.
Cheers mate