79769507

Date: 2025-09-19 12:43:17
Score: 0.5
Natty:
Report link

Using INDIRECT to reference a string in a cell as a range

=SUMIF(INDIRECT(I1), TRUE,INDIRECT(J1))

Note that with this formula, you would have to place the first parameter B2:B76 in its own cell as well, in this example I placed it in cell I1

References: INDIRECT

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: 4thAnd1