Forum Discussion
Kim_Nelson
Feb 03, 2023Copper Contributor
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...
- Feb 03, 2023sounds like a COUNTIFS type of statement. =COUNTIFS(D:D,"Achieved Excellence",E:E,"*cash*")
mtarler
Feb 03, 2023Silver Contributor
sounds like a COUNTIFS type of statement. =COUNTIFS(D:D,"Achieved Excellence",E:E,"*cash*")
Kim_Nelson
Feb 03, 2023Copper Contributor
Thank you so much it worked!!!!!! I really appreciate your help.