79354974

Date: 2025-01-14 12:27:50
Score: 2
Natty:
Report link

The second method using the INDIRECT function works and you can just simply put the CONCAT statement in to the INDIRECT function, you don't need to put it in a separate cell

Eg: COUNTIF(INDIRECT(CONCAT("Start ",A1," End")),[Criteria])

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: user29193099