How to add cells wiht the condition of the former cell.

R

Rafael

For example: If the previus cell has a "5". How can I add all the cells whose
previous cell is a "5".
How can write this in a correc way in excell.
 
R

rvr01m

No.
What I want is to add all the hours a man has work in a schedule. Everyone
have a code in it. Example Peter is number 5 and in the next cell apears the
hours he worked.
 
P

Peo Sjoblom

Are you using another delimiter? Try

=SUMPRODUCT(--(A1:A9=5);A2:A10)


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top