E
excellover
Hi Frank
The sumif function works just fine thank you , here is one issue
forgot to mention in my post , in some instances I would have to inpu
two criteria to get the correct input , assume jerry makes $400 if h
drives a Mazda or $200 if any other model , how would sumif comman
differentiate
e.g.
In cell a1, I will input Jerry
In cell a2, I will input Mazda
How can I use cell a3 to pickup $400 instead of $200?
In addition, how can I use cell a3 to pickup $200 if he drove any othe
model?
Your help is always appreciated
The sumif function works just fine thank you , here is one issue
forgot to mention in my post , in some instances I would have to inpu
two criteria to get the correct input , assume jerry makes $400 if h
drives a Mazda or $200 if any other model , how would sumif comman
differentiate
e.g.
In cell a1, I will input Jerry
In cell a2, I will input Mazda
How can I use cell a3 to pickup $400 instead of $200?
In addition, how can I use cell a3 to pickup $200 if he drove any othe
model?
Your help is always appreciated