ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need Help Creating a Formula (https://www.excelbanter.com/excel-worksheet-functions/178866-need-help-creating-formula.html)

sferguson

Need Help Creating a Formula
 
I have a spreadsheet with three worksheets. Each worksheet is for a month.
On each worksheet Column A holds the name and columns b and following hold
the day of the month. Example - cell b2 in all is 1 - hope that makes sense.

I am trying to create a formula that will tell me if 29 consecutive cells
are empty or have something in them. If all 29 are empty then I need the
formula to return a -1.
If there is something in one of the 29 consecutive cells the formula would
not need to return any information. The problem is I need it to count from
worksheet to worksheet consecutively. IE - the January worksheet cell f2
would need to count consecutively through the end of it into the February
worksheet cell c2 (this would count from January 5 through February 2 - which
would be 29 consecutive days). Does anyone know if I can create a formula
that would do this?

I've had success counting the 29 consecutive days when they are one
worksheet, but not when I have to count the days from seperate worksheets.

Thanks for your help!


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com