Excel/Formulas & Functions

[Kim_Nelson]

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.

[#2 · Accepted solution]

sounds like a COUNTIFS type of statement. =COUNTIFS(D:D,"Achieved Excellence",E:E,"*cash*")

[#3]

@Kim_Nelson 

An alternative could be SUMPRODUCT.

=SUMPRODUCT((D:D="Achieved Excellence")*((E:E="time off award")+(E:E="cash award")))

[#4]

Thank you so much it worked!!!!!! I really appreciate your help.

[#5]

Thank you tremendously.