General discussion

Locked

Excel forumula for Budget

By mack_shane ·
I would like a formula that will do the following:

There are 3 codes for Column 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 conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel forumula for Budget

by DKlippert In reply to Excel forumula for Budget

Please make another run at describing what you want.

Collapse -

Excel forumula for Budget

by DKlippert In reply to Excel forumula for Budget

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.

Collapse -

Excel forumula for Budget

by mack_shane In reply to Excel forumula for Budget

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

Cheers

Collapse -

Excel forumula for Budget

by mack_shane In reply to Excel forumula for Budget

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.

Collapse -

Excel forumula for Budget

by mack_shane In reply to Excel forumula for Budget

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.

Collapse -

Excel forumula for Budget

by mack_shane In reply to Excel forumula for Budget

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums