Adding together a bunch of IFNUMBER

Hi!

I am very new to excel, and I think way over my head here. lol

In the attached file I am trying to add together a bunch of IFNUMBER into one total. V6 is where the formula currently is, its not working, and I don't know what I am doing wrong. Please help.

=IF(ISNUMBER(G6),G6*G1,IF(ISNUMBER(H6),H6*H1,IF(ISNUMBER(I6),I6*I1,IF(ISNUMBER(J6),J6*J1,IF(ISNUMBER(K6),K6*K1,IF(ISNUMBER(L6),L6*L1,IF(ISNUMBER(M6),M6*M1,IF(ISNUMBER(N6),N6*N1,IF(ISNUMBER(O6),O6*O1,IF(ISNUMBER(P6),P6*P1,IF(ISNUMBER(Q6),Q6*Q1,IF(ISNUMBER(R6),R6*R1,IF(ISNUMBER(S6),S6*S1,"")))))))))))))

Thanks!

You don't explain what you want your formula to do, so it's hard to say how to correct it.

However, it appears from context that for each product, you want to multiply the quantity times the unit cost to get a total cost for that product, and then sum the total costs for all the products. The SUMPRODUCT function is perfect for this:

Formula:

Please Login or Register  to view this content.

I'll take a moment to explain why your formula doesn't work. IF has three parts: The condition, the result if the condition is TRUE, and the result if the condition is FALSE. You have nested many IF functions together, so as soon as one of the conditions is TRUE it returns the TRUE result and finishes. There is nothing in your formula to add the results. For example, if G6 is a number, the formula returns G6*G1 and then it's done.

You don't have to worry about the cells that are blank. When Excel does arithmetic, it will treat a blank cell as 0.