Excel/Formulas & Functions

New Contributor

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.

4 Replies
best response confirmed by Kim_Nelson (New Contributor)
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 so much it worked!!!!!! I really appreciate your help.
Thank you tremendously.