Forum Discussion
Solved
COUNTIF not working with arguments defined by LET function
I have a data table with key index as XXX_ID (Data!$A:$A), including a list of XXX IDs for each data rows, and there are repetitive IDs in the column as data in other columns are different. I need t...
- Countifs() argument criteria_range doesn't work on calculated values. It only works on pure range.
Countifs() argument criteria_range doesn't work on calculated values. It only works on pure range.
Thanks for the explanation! May I ask why COUNTIF/COUNTIFS don't work with calculated values? If there are no specific reasons behind such setting, how can I raise a ticket to MS Excel development team to review upgrading the two functions?
BTW, I don't see anything regarding not being able to use calculated values in:
https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34
and
https://support.microsoft.com/en-us/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842
BTW, I don't see anything regarding not being able to use calculated values in:
https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34
and
https://support.microsoft.com/en-us/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842