Trying to figure out the formula

[jlschoultz]

Okay, so after reading some of these questions I feel really excel stupid, but I won't get any smarter if I don't ask so...
I'm trying to create a formula where excel will add numbers in one column only if the adjacent column's drop down list is on a certain value and then subtract that total from another cell. Does anybody know how to do that?

 

[Michael M]

Have a look at the SUMIF function.
So, basically if you wanted to only sum numbers in column "A" from A1:A100, if column "B" said "yes",
you would use

=SUMIF(B1:B100,"yes",A1:A100)

Regards
Michael M

 

[jlschoultz]

Thank you so much! That was exactly what I needed!

 

[Michael M]

my pleasure....and a belated Welcome to the Board

Regards
Michael M

 

[jlschoultz]

Thanks for the Welcome as well!