Not sure what to use

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that is giving me fits

64 $16.87 Grader 164 $17.87 Grader 3 167 $19.44 Grader 3 99 $19.4
N/A N/A Crusher N/A N/A Crusher/Mine 45 $15.86 HT/Gr/Doz/Dr 99 $17.8

I have to create a formula that will multiple the numbers next to each other then add the results of the two numbers with each other. For example,
=(64*16.87)+(164*17.87)+(167*19.44)+(99*19.44
Notice the second row has "N/A" and numbers. The formula has to continue down and multiple any numbers in that row. Any ideas of what type of formula to use? I have tried If Statement, SumIf, If/Or
Thanks
 
Hi Janet!

Assuming first item of your data example is in A1:

=IF(OR(A1="N/A",B1="N/A"),0,A1*B1)+IF(OR(D1="N/A",E1="N/A"),0,D1*E1)+I
F(OR(G1="N/A",H1="N/A"),0,G1*H1)+IF(OR(J1="N/A",K1="N/A"),0,J1*K1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Janet said:
I have a worksheet that is giving me fits:

64 $16.87 Grader 164 $17.87 Grader 3 167
Click to expand...
$19.44 Grader 3 99 $19.44
N/A N/A Crusher N/A N/A Crusher/Mine 45
Click to expand...
$15.86 HT/Gr/Doz/Dr 99 $17.88
I have to create a formula that will multiple the numbers next to
Click to expand...
each other then add the results of the two numbers with each other.
For example,
=(64*16.87)+(164*17.87)+(167*19.44)+(99*19.44)
Notice the second row has "N/A" and numbers. The formula has to
Click to expand...
continue down and multiple any numbers in that row. Any ideas of what
type of formula to use? I have tried If Statement, SumIf, If/Or.
 
Hi Janet!

Always pleased to help and know a solution works for the poster.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top