If then in excel

  • Thread starter Thread starter Dragonomega
  • Start date Start date
D

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
 
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
 
Back
Top