Hello all,
I have a spreadsheet with two header rows and two header columns. The Leftmost
header row lists each month. The second header row list individual transactions
for each month. The leftmost header row is a merged cell so that all of the
January transactions fall into the January header.
You seem to be mixing terms. you refer to “leftmost” header rows and “top”
header row. Rows can’t be leftmost or rightmost, they’re stacked one above each
other. Just as header columns are vertical columns each next to the other.
I don’t really understand your question the way you posed it. I can
My mistake. Let me repost with the correct terms.
Hello all,
I have a spreadsheet with two header rows and two header columns. The Leftmost
header column lists each month. The second header column list individual
transactions for each month. The leftmost header column is a merged cell so
that
you could try an experiment. create your formula using e5:h10 as you call it,
and see how numbers translates that to column/row header references.
example, If I reference a cell like C5 in a formula, and column C has a header
reference of March, and row 5 has a header reference of Wednesday, the
That’s a good idea, but in this case Numbers does not change the cell
references into header names. It works if I want to sum the cells in one
column, say Electricity, over the range of rows under the header of January,
but for whatever reason it won’t let me sum multiple columns, such as the 4