I am trying to write a formula that adds the number of new programs submitted by a particular person. Example.
If column B3:B100="smith", then I want to sum A3:a100 if it equals "new".
I can't figure out the formula without entering to many exceptions. Any suggestions?
Thanks!
If column B3:B100="smith", then I want to sum A3:a100 if it equals "new".
I can't figure out the formula without entering to many exceptions. Any suggestions?
Thanks!