Conditional Formula?

[rhovey]

Hi- I need help creating a formula that sums values in a list based on
the value in an adjacent cell. Please see attached screen shot.
Hopefully it explains what I'm trying to do.

Thanks.


+-------------------------------------------------------------------+
|Filename: excel help 3-10-06.gif |
|Download: http://www.excelforum.com/attachment.php?postid=4442 |
+-------------------------------------------------------------------+

 

[SteveG]

Sounds like you could use SUMPRODUCT or SUMIF to get what you want.

Say your cash/lease drop downs are in column A. Where you want your
cash total you could use,

=SUMPRODUCT(--(A1:A100="Cash"),--(B1:B100))

For lease

=SUMPRODUCT(--(A1:A100="Lease),--(B1:B100))

or

=SUMIF(A1:A100,"Cash",B1:B100)

=SUMIF(A1:A100,"Lease",B1:100)


Does that help?

Steve