Multi Calculation from start row/end row formula?

Hi all,
Been working on a formula most of the day and I am just stumped!
Formula below is almost there but one issue.
This formula calculates between col A "2" (will not calculate above that row) and Col B "Project Completion" (will not calculate below this row). Col A "2" is my WBS number.

Now, Col "N" in the formula works great, but Col "M" only works and wont calculate above A "2", but it will calculate below Col B "Project Completion", See formula! These are all date fields that bring me a number. I don't get why Col N works and Col M doesn't. Any one have any suggestions?

Please Login or Register  to view this content.

Thanks
Dave

Thank you,
Removing the "" did the trick! Wow, spent several hours on that. I feel stupid right now but glad it is solved.
Thanks Again!
Dave

Well, I guess I was wrong? It still doesn't work?
I have attached a copy sample.
Formulas are in the Scheduled days and Calendar Days (Actual)
Basically we don't count days "Mobilization" in a schedule so those days don't count as Schedule Days and I don't count anything after punch for scheduling, that's why I don't want to count anything above WBS "2" and just to the line above "Project Completion" I put dates in lower and higher in the Columns before "2" and after "Project Completion" and they all work good except when I put a lower date in after project completion then the lowest below "2". This is only affected in Columns D and M? Have no idea! Those two columns wont stop at "Project Complete"
Thanks

Sure,
I want to calculate the days between WBS "2" and "Project Completion" The min day to the max day and give me a number of days total of that. I want to take max of column F and the min of column E between the "2" and "PC" rows. Same for Columns N and M. Start Date and Finish Date is Schedule, Actual Start and Actual Finish is project. They assist with analyzing future projects. So, the formula I have will work for the most part, yet there is that 1% of the time so I am trying to get it correct.

If you put dates in above "2" or below "PC" they should not be part of this calculation. The only part that hasn't worked is when I put a date before the lowest date below the "PC" but that shouldn't matter as it shouldn't be calculating there anyway?

Hope this helps
Dave

Hi FDibbins,
I am wondering if I need both the "IFERROR (Match" sections in each of the MIN/MAX. Maybe I am not telling each section to start here and stop there? But then again, the Max formula works both ways just perfect? I don't get it.
Thanks

Was sort of getting brain dead last night, sorry. A quick glance, what I wan to do here is:

Calculate the Number of Days (Max Col F - MIN Col D) starting at "Col A, WBS #2" and stopping at "Col B, Project Completion)" and storing this number in Cell(L2) per my sample above. Keeping in mind that WBS #2 will always be WBS #2 and the "Project Completion" Wont change except adding to it and how many task summaries and sub task rows are added between. So, no matter what "date" I put in before WBS #2 in the dates fields, or "Project Completion" and after, this will not affect this Calculation of amount of days in (L2).

I need to do the same with (L3) for NETWORKDAYS also if you have any ideas on that.

The reason for this (FYI) is WBS #1 is always Mobilize and does not count in the schedule however needs to be on schedule for general condition reasons for one. Next, When I schedule a project I schedule from start date to Project Completion, leaving out Project Completion of the equitation as all actual work in reality should be completed before punch. Calc these days in the manor I want is to let me know when I schedule a project I scheduled this many days of work and once I get completed with that, then I can analyze and make corrections if necessary. Lets say I have a project 200 days to complete. I scheduled 180 of that in the schedule days, 145 of that is NETWORKDAYS. Well, I figure I will need 30 days of punch and close out days so, this tells me I can run a 5 day work week with some weekends to make that happen. If I schedule 230 days of work, then I need to go back and find where I can cut days or say, no, we cant do it in 200!

Thanks
Dave