780tuners.com Edmonton Car Forums - MS Excel Help Needed

Edmonton Car Forums > 780Tuners Edmonton Car Forums Archive > General Chat Non-Automotive > Computers, Games and Electronics

MS Excel Help Needed - Click HERE for Original Thread

Kyle2K

anyone know why the following equation gives me "#VALUE!"?

=SUM((H34:I34)*M3)

stuff

Try This

=SUM(H34:I34)*M3

Mustard

do either of the cels your adding contain characters?

ie.

if you have 130 km in cel A1 and 4 h in cel B1
and you put in C1
=A1/B1
you would not get 32.5 km/h
you would get #value, cause it doesn't like "km" or "H"

make sure you format the cels to contain numbers only.

Do you want to post a reply? This is the 780tuners.com archive, to participate in daily discussions on cars, visit our forums website and register today! Its free.

< Contact Us - 780Tuners Edmonton Car Forums - Advertising Info - Archive >