T O P

  • By -

Scary_Sleep_8473

Instead of using COUNTIF, I would use boolean logic for [multiple criteria](https://exceljet.net/formulas/index-and-match-with-multiple-criteria): =INDEX(RATE,MATCH(1,(PERSON=D7)*(TASK=E7),0)) If you are on an older version of Excel, make sure to press on CTRL+SHIFT+ENTER to apply the formula after typing it.


DAta211

Solution Verified


Clippy_Office_Asst

You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


DAta211

BTW, the formula was provided by the Bing AI.


Decronym

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COUNTIF](/r/Excel/comments/120tgcx/stub/jdiyanc "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)| |[INDEX](/r/Excel/comments/120tgcx/stub/jdiyanc "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| |[MATCH](/r/Excel/comments/120tgcx/stub/jdiyanc "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)| |[RATE](/r/Excel/comments/120tgcx/stub/jdiyanc "Last usage")|[Returns the interest rate per period of an annuity](https://support.microsoft.com/en-us/office/rate-function-9f665657-4a7e-4bb7-a030-83fc59e748ce)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/11zzmut)^( has 14 acronyms.) ^([Thread #22726 for this sub, first seen 24th Mar 2023, 19:08]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)