how to make forumla that treat blank cells as a zero?

I'm quite new at this, so bear with my ignorance...

I have this situation

A B C D
1 2 5 6
2 3 6 7
3 4 8
4 5 7
5 6 8 9
6 7 9 10

I want to create a formula that does this
=(A1*5)+(B1*10)+(C1*10)+(D1*20) (just an example)
But when I use Autofill it says value error with C3 and D4 because it is blank... I want to make the formula count the blank as zero making the last part in the add zero but still adding the rest up. I tried with the IFBLANK but I couldn't succeed

Please help, and sorry if this is very low tech

Sorry, I thought I could create a example that fitted situation. This is my real formula and the problem is that some of the cells are blank, and I want the same thing

=(F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)+(R3*S3)+(U3*V3)

The thing is that I am using autofill, and in some of the colons the cells are blank (O3, S3, V3). Obviously if Excel treated this as zeros the last 3 paranthesis should be zero, but how to do this?

Thank you for replying my n00bie question

The first question was only an attempt to examplify my problem. The long formula in the last question is the exact problem so can I preserve this formula
=(F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)+(R3*S3)+(U3*V3)
and get to threat the last three parenthesises as zero IF one or more of the variables is a blank cell. Following cells could be blank: I3, J3, L3, M3, O3, P3, R3, S3, U3, V3

disregard the first question as it was a faulty attempt to create a fictive example

possible?

I am very sorry for being so ignorant, but your somthing:something.... Doesn't that mean the range? Some of the colons are not to be included in my formula, and the {}, I don't know what to put in them in the last formula Gave you. This is my best shot


=SUMPRODUCT((F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)+(R3*S3)+(U3*V3), {and what goes here})

It is to be used for autofill som all of the before-mentioned cells can be blank

because it is not the result of formulas...
It is because some rows have blanks in the before-mentioned columns and some have numbers, and as I want one formula to cover all possibilities (e.g. some where O3, P3, ect. is blank and some where only V3, Y3, ect is blank)

So I want to create the formula that does
=(F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)+(R3*S3)+(U3*V3)
where any of the varibles (numbers) can be blank and will be counted as zeros
examples:
=(F3*G3)+(I10*J3=0)+(L3*M3=0)+(O3*P3=0)+(R3*S3=0)+(U3*V3=0)=(F3*G3)
=(F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)+(R3*S3=0)+(U3*V3=0) = =(F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)
=(F3*G3)+(I10*J3)+(L3*M3=0)+(O3*P3=0)+(R3*S3=0)+(U3*V3=0) =(F3*G3)+(I10*J3)

This will happen in my stastistics at some point, and I need my formula to account for this

Can't I write something "before"/"after" or "between" the original formula
=(F3*G3)+(I10*J3)+(L3*M3)+(O3*P3)+(R3*S3)+(U3*V3)
that threats the blanks as zeros?
Isn't there a command that says, If any of the variables are zero "" then they should be understood as zero but that still calculates the rest?

I am sorry that my skills is not better to explain what I mean but this would really make mhy day

Holy numerical conversion Batman! I have done so many workarounds, I didn't know there was a formula for it. Using the N() function is a game changer for me.