using number of sheets in a formula

F

Fawn

I have a workbook with several sheets that roll up to a YTD. What I want to
do is to have one of the columns multiply by the number of sheets in between
the start and end sheets.

For example


Weekly target is YTD

3300 YTD will be 3300 *(# of sheets)


Is this possible


Any help would be appreciated

Thanks
 

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

YTD SUMIF based on current date 3
Section and Page numbering 0
Totaling Categories - Monthly and YTD 2
Help with an IF Statement 1
Help with year to date comparison 4
if function (if more that 7 nesting) 2
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria 0
determine a range using a formula 2

Top