General discussion
January 13, 2003 at 07:40 AM
mack_shane

Excel forumula for Budget

by mack_shane . Updated 23 years, 8 months ago

I would like a formula that will do the following:

There are 3 codes for Column D: V, Q, or S.

Example: If D2=V, then the value in H2 would be added into cell H40. Then if D3=V too, then the value of H3 would be added into cell H40. If D4=V, then the value of H4 would be added into cell H41. Cell H42 would be used for values that had a code of S.

The outcome is meant to be that there will be 3 cells with values in that are made up of whether the data has a code of V, Q, or S.

Sorry if this is confusing, it’s harder to write what I want than it is to think about it in my head.

Cheers

This discussion is locked

All Comments