Forum Discussion
Solved
Excel/Formulas & Functions
I'm trying to figure out a formula in Excel that will show how many employees received an Achieved Excellence award that requested either a time off award or cash award? How can I create a formula th...
- sounds like a COUNTIFS type of statement. =COUNTIFS(D:D,"Achieved Excellence",E:E,"*cash*")
An alternative could be SUMPRODUCT.
=SUMPRODUCT((D:D="Achieved Excellence")*((E:E="time off award")+(E:E="cash award")))
Thank you tremendously.