0
votes
1answer
680 views

Excel - can't get the formula to copy correctly

Have an excel sheet. I want B3 = C3 * C2 So far everything is good. I want B4 = C4 * C2 Did these two manually. I have a lot of rows so I wanna copy the formula. The problem is, I select them ...
0
votes
0answers
117 views

How to get new data to automatically slot into correct column in Excel?

I am trying to move new data into an existing database with set columns. The existing database has a column for every possible type of data, but not all new entries contain all columns. So I can't ...
0
votes
3answers
103 views

Calculating a sum on an integer column when another column includes the year criteria for the calculation

I have a spreadsheet where the columns contain values as follows: Column(A) B C D E NameA 01/02/2010 5 4 5 NameB 05/06/2011 4 3 ...
1
vote
2answers
90 views

MS Excel: How to work with a column chosen by value in header (row1)

I am importing a large dataset from a website and I want to build some summary stats on a new sheet. The column order is not fixed, so I want to be able to (for example) count all the cells with the ...
2
votes
2answers
2k views

Summing a column in the same column without a circular reference

In Excel you can sum a whole column with =SUM(B:B). But of course you can't use that formula in the column you want to sum, because you'll get a circular reference. Is there an easy way of summing ...