Software

Ask something
Discussion Locked

Excel forumula for Budget

0 helpful
6 replies

by mack_shane

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

6 replies

by dklippert

Great!
Your're looking for a SUMIF formula

entered into H40,H41, and H43 might be formulas:
=SUMIF(D2:D30,"V",H2:H30)
=SUMIF(D2:D30,"Q",H2:H30)
=SUMIF(D2:D30,"S",H2:H30)

The first argument is the range containing the codes. The second is the code check. The third is the range that is to be summarized.

by mack_shane

Thank you very much. This worked perfectly and was a lot easier than what I thought it would be.

Cheers

by mack_shane

I have a budget document. In column H there are all $ amounts. In column D I have a code (either V,Q,S) for each item.

I want a forumula that will total all the amounts that have a code of V only, then the same for Q only and S only.

by mack_shane

I have a budget document. In column H there are all $ amounts. In column D I have a code (either V,Q,S) for each item.

I want a forumula that will total all the amounts that have a code of V only, then the same for Q only and S only.

This discussion is closed to new replies.