Include 1-x columns in @Sum depending on date

M

Moira Mack

I have 12 columns, one per month
The formula for the Total Column should include only the
columns to represent a year-to-date total. How would I do
this?

Jan Feb Mar Apr May
1 1 1 1 1

In March the total would be 3, in April the total would be
4.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can count the number of cells that fulfill certain criteria in other cells 2
Countifs or a pivot 1
Find the position of a date 6
Extracting data from Multiple columns to a Single row 3
Calculating total amount in a Pivot Table 1
sum columns between certain dates 1
Summing a non continuous range 7
How to avergage colums 7

Top