Help with google spreadsheet/Excel Formulas?

[Dark Mod]

I need some help with excel/google spreadsheet formulas. Basically i am running a group buy for ammo, and i want to organize everyones orders.

There are different prices for different calibers, is there a way i can input a price per thousand so when i put down that someone wants 250 .45, 1000 9mm, and 3500 .40 it will automatically calculate it?

any help would be greatly appreciated

Also does anyone know how to make a simple add formula be the standard for all columns? like adding up everyones total order afterward without having to type in a new formula for each line?

thanks in advance!

[sandman21]

PM sent

[Dark Mod]

BIG thanks to Sandman21 who made the whole thing for me!