You're welcome, Drew - thanks for feeding back.

Pete

On Jun 30, 12:12*am, "Drew" wrote:
perfect ... thank you Pete.

"Pete_UK" wrote in message

...
You could try this amendment:

=IF(ISNA(MATCH(F10,F4:Q4,0)),"-",E4*COUNTIF(F4:Q4,F10))

Hope this helps.

Pete

On Jun 29, 2:22 pm, "Drew" wrote:



Pete et al ... now I have identified a problem. Not yours but mine.

In the F4:Q4 range, if the match ( to F10) is found twice, the formula
only
returns one instance of E4.

Is there a minor modification that would multipy E4 by the number of
matches
that are found F4:Q4 please?

Kindest thanks for the assistance.

Drew.- Hide quoted text -

- Show quoted text -