# Software

## General discussion

Locked

### Excel forumula for Budget

By ·
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.

Thread display: Collapse - | Expand +

## All Comments

Collapse -

### Excel forumula for Budget

by In reply to Excel forumula for Budget

Please make another run at describing what you want.

Collapse -

### Excel forumula for Budget

by 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 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 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 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 In reply to Excel forumula for Budget

This question was closed by the author

## Related Discussions

• 4

#### Scheduling software

soniamadison0 ·

• 7

#### What is an effective time tracker?

egormishinwork ·

• 1

swanbellqa ·

• 5

vassy101 ·

• 1

#### Graphic analysis

DmitriDelta ·