Hi!
Our band director is looking to create a spreadsheet which will calculate scores from our upcoming county band auditions. I know the sum formula and can put that in a cell, however, she would like to put it into an entire column, without typing the formula or copy and pasting it 100 times. So for example, no matter which cell you click on in Column C, it automatically adds up column a and b. I've tried highlighting the column and typing in the formula, but it gives me an error message. Can what I'm asking be done?
Tags: Excel, formulas, spreadsheets

▶ Reply to This