Countif (filling blank rows)

[Median]

I just wondered if it was possible (that with a slight modification) the formulas in KP2:WC5 could "fill the rows" which have the same ID (i.e. end up looking like WE2:AHR5)

Cheers
Mdn

[FDibbins]

This might have been easier to "manage" if you went down, instead of across (you could still swap them around pretty easily using copy/paste transpose)

You could probably do what you want using INDEX/MATCH, but which cells/values do you want to pull in?

Im a little puzzled by the formula you have in KP5...

Please Login or Register  to view this content.

That is essentially testing if a count in a small range in AHT is the same as a count of the full AHT column?

Perhaps you could explain what you are trying to do here?

[Median]

The proper data is much larger (thousands of rows); & I was trying to sum everything with the same ID i.e.

Du96Io3CRYeNsm4jYIu0Hw.png

Which works great, but I didn't anticipate the formula only providing a value for the last ID, rather than all the IDs with the same value (i.e. KP2, KP3, KP4 should have the value 271786.17)

[FlameRetired]

I didn't anticipate the formula only providing a value for the last ID, rather than all the IDs with the same value (i.e. KP2, KP3, KP4 should have the value 271786.17)

Then skip the IF test and do just

Please Login or Register  to view this content.

It does that.

[Median]

Dave, you're a complete legend (as always)

[FlameRetired]

Thanks for the feedback and rep. Glad to help.

[FDibbins]

Thanks for the rep