cumulative total

T

T McShu

I have a client who wants me to include on his monthly invoice, every
consultant who has worked on the contract, the number of hours each
consultant has worked that month and the number of cumulative hours each
consultant has worked. I have tried a simple formula that I found in a help
forum but it seems to update all cumulative cells.

Say for instance I have 3 columns:
consultant # hrs worked in Oct # hrs worked total on contract

I may have 10 consultants on 1 project and I need only his cumulative total
in the 3rd column.

Any help would be appreciated.
 
S

Sheeloo

If you have Consultant name in Col A, Contract Id in Col B and hours in Col
C, then the following will give you all the hours for "Adam", for Contract
"ABC";
=Sumproduct(--($A$1:$A$100="Adam"),--($B$1:$B$100="ABC"),($C$1:$C$100))

You can also have
=Sumproduct(--($A$1:$A$100=A1),--($B$1:$B$100=B1),($C$1:$C$100))
if A1 contains Adam, B1 conatins ABC

Change 100 to the last row in your data

T McShu said:
I have a client who wants me to include on his monthly invoice, every
consultant who has worked on the contract, the number of hours each
consultant has worked that month and the number of cumulative hours each
consultant has worked. I have tried a simple formula that I found in a help
forum but it seems to update all cumulative cells.
 

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

Top