Tagged Questions
0
votes
3answers
84 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
68 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
1k 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 ...
