Creating a work load spreadsheet

Hi

I'm currently trying to put together a spreadsheet that will identify my work load per quarter. Currently the spreadsheet looks something like this http://img165.imageshack.us/img165/8617/testku6.jpg

What I need to do is automatically calculate the workload between planning and implementing plan etc. If I beging planning in Q1 and implement plan in Q3 thats 3 quarters it has taken to plan.

So I reckon I somehow need to countblank between P and IP and also between IP and C. I'm just unsure of how to tell the function only to calculate between P and IP etc along each row.

I'm more than happy if anyone has some suggestions on how to start this from scratch and take a different design as the spreadsheet is now being asked to produce figures that it was not initially designed to do.

Hope I’ve explained myself OK and thank you in advance for any help.

Warren

Hi,

Could the Countblank() function be of any help ...???

Cheers
Carim

assuming P and IP are in A to M, in N put:

=COUNTBLANK(OFFSET(A1,0,MATCH("P",A1:L1,0)-1):OFFSET(A1,0,MATCH("IP",A1:M1,0)-1))

---

Originally Posted by Warren

Hi

I'm currently trying to put together a spreadsheet that will identify my work load per quarter. Currently the spreadsheet looks something like this http://img165.imageshack.us/img165/8617/testku6.jpg

What I need to do is automatically calculate the workload between planning and implementing plan etc. If I beging planning in Q1 and implement plan in Q3 thats 3 quarters it has taken to plan.

So I reckon I somehow need to countblank between P and IP and also between IP and C. I'm just unsure of how to tell the function only to calculate between P and IP etc along each row.

I'm more than happy if anyone has some suggestions on how to start this from scratch and take a different design as the spreadsheet is now being asked to produce figures that it was not initially designed to do.

Hope I’ve explained myself OK and thank you in advance for any help.

Warren