If then in excel

[Dragonomega]

i need to set up a spreadsheet for work and am having difficulties figuring a
way to handle credit cards i would like to set it up so that i can do
something like (if column has AX {american Express} then add the adjacent
columns #) please assist

Thanks

 

[Brad]

Two different methods
What I think you want is

=SUMIF(C2:C8,"American Express",D28)
Where the credit card name is in C and the values are in D

or

=SUMPRODUCT(--(C2:C8="American Express"),D28)
Where the credit card name is in C and the values are in D