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

Two different methods
What I think you want is

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

or

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

--
Wag more, bark less


"Dragonomega" wrote:

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