cumulative total

[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.

 

[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

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.