Possible Index Match Count Formula Help

[Celticshadow]

Hi Forum

I am hoping forum may be able to help me with a formula concerning two lists I have which are growing by the day.

The first list contains a horse trainers name in one column with alonside in the adjacent column has a number which reflects the amount of runners said trainer has ran in last x amount of days. The second list has a list of horse trainers and alonside in the adjacent columns are the result (numerical placing) and the name of the horse the result corresponds to. What I would like to do is count how many fig 1's are associated with the trainers in second list and match them up to trainers name in first list and place the result of count next to the amount of runners column in first list. I have attached an example to hopefully make things appear a little clearer.

For example if I filter list two for R M Becket I can physically count that he has had 12 wins (or number 1's) and I would like to place that figure 12 after the count in col C in first list next to his name.

I thanks forum in advance for any help received and look forward to hearing from you.

Regards

 

[SanjayGMusafir]

Try this -

=COUNTIFS(D:D,A3,E:E,"1")

 

[Celticshadow]

Try this -

=COUNTIFS(D:D,A3,E:E,"1")

Hi Sanjay

Many thanks for your reply it is much appreciated. Unfortunately when I enter your formula I end up with the answer "True* instead of 12 which is the number of wins associated with R M Becket.

Regards

 

[SanjayGMusafir]

when I enter your formula I end up with the answer "True* instead of 12

The formula is not supposed to return TRUE or False it's meant to return a number

Can you share what formula you have actually posted

 

[Celticshadow]

Hi Sanjay

Yes sure no problem please see attached snapshot showing formula entered.

Regards

 

[SanjayGMusafir]

Yes sure no problem please see attached snapshot showing formula entered

You missed quotes around 1. Try this -

=COUNTIFS(D:D,A3,E:E,"1")

 

[Celticshadow]

You missed quotes around 1. Try this -

=COUNTIFS(D:D,A3,E:E,"1")

Hi Sanjay

Please accept my sincere apologies you are of course perfectly correct and I am delighted to say your solution works a treat, many many thanks for taking time out to kindly share your time and expertise it is much appreciated. Superb.

Regards

 

[SanjayGMusafir]

Hi Sanjay

Please accept my sincere apologies you are of course perfectly correct and I am delighted to say your solution works a treat, many many thanks for taking time out to kindly share your time and expertise it is much appreciated. Superb.

Regards

Glad to help you