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.

[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