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 that will give me this information?
For example in cell D2 you have the type of award and in cell E2 you have the employee's award preference. I'm trying to show how many employees that received an Achieved Excellence requested either a cash award or time off.
- 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.
- sounds like a COUNTIFS type of statement. =COUNTIFS(D:D,"Achieved Excellence",E:E,"*cash*")
- Thank you so much it worked!!!!!! I really appreciate your help.
