SUM value when 31 rows selected and not all have values

[mindstyle]

Hello!

I have two more questions..

1. I made a template for monthly basis (table, formulas, graphs etc..), now id like to use it for every new month in the same workbook (one month = one new page), is there a way to automatically do it? Maybe even put in the month and year automatically as page name?
Then, if it is possible, for these months to be auto filled in a separate page where yearly statistics will be( a table with names of months and overall profit from each month, the profit of each month is in one cell in each month's page)?

I hope i didnt complicate the question too much im attaching a screen(1) for better visualisation.


2. I have a column of profits per day for every month (max. 31) and then i make a sum of all those profits for total monthly profit. These are added manually and i would like to get a sum of all the profits where selected rows are 1-31 (for the max. days a month can have) even when all 31 fields are not filled in yet, because now i get N/A as all 31 fields dont have a value yet. I am attaching a screen(2) for this also.

[pblnrao]

if u could upload ur sample excel it will be more clear...

its possible to achieve what u are asking for in the workbook.

Hello!

I have two more questions..

1. I made a template for monthly basis (table, formulas, graphs etc..), now id like to use it for every new month in the same workbook (one month = one new page), is there a way to automatically do it? Maybe even put in the month and year automatically as page name?
Then, if it is possible, for these months to be auto filled in a separate page where yearly statistics will be( a table with names of months and overall profit from each month, the profit of each month is in one cell in each month's page)?

I hope i didnt complicate the question too much im attaching a screen(1) for better visualisation.


2. I have a column of profits per day for every month (max. 31) and then i make a sum of all those profits for total monthly profit. These are added manually and i would like to get a sum of all the profits where selected rows are 1-31 (for the max. days a month can have) even when all 31 fields are not filled in yet, because now i get N/A as all 31 fields dont have a value yet. I am attaching a screen(2) for this also.

[mindstyle]

Thanks, i already solved my first problem, now i only need a solution to my second problem:

2. I have a column of profits per day for every month (max. 31) and then i make a sum of all those profits for total monthly profit. These are added manually and i would like to get a sum of all the profits where selected rows are 1-31 (for the max. days a month can have) even when all 31 fields are not filled in yet, because now i get N/A as all 31 fields dont have a value yet. I am attaching a screen(2) for this also.

I uploaded the whole worksheet.


Thanks in advance