# Tagged Questions

**0**

votes

**1**answer

690 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

**0**answers

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

**3**answers

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

**2**answers

91 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

**2**answers

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 ...