Forum Discussion
countif / index / match
Hi Twifoo Are you able to help me with a formula? I am having trouble with countif/index/match.. I need to look at a range of data (+PLOD'!$H$2:$AX$1048576) and count the number of times a f...
Recently, I eschewed the repetition of ISNUMBER-FIND in my reply here:
Similarly, the repetition of SUMPRODUCT in my suggested formula could also be eschewed like this:
IFERROR(1/(1/(
SUMPRODUCT((PLOD1=C1)*
(PLOD2='PLOD SUM'!B2)))),
"No Data")