Count IF issue

[trainer75]

Good day,

wonder if anyone can assist me with some countif problems.

I have a spreadsheet that i need to count how many instances of a number
example

Column A (other info in these columns not needed) Column H
Tyres 6
Tyres 6
Tyres 7
Tyres 6
Tyres 7
Tyres 6
Exhaust 6
Exhaust 7
Exhaust 7
Exhaust 7
Chains 6
Chains 7

and so on, the number of rows vary week on week.

i want to sort out a formula that will say if Tyres is in column A then count how many 6 in column H there is against it.

Any help is appreciated

 

[Marcelo Branco]

Try

=COUNTIFS(A:A,"Tyres",H:H,6)

Hope this helps

M.

 

[trainer75]

That is spot on,
Thank you, it was a simple as that, i was thinking too deep.
Much appreciated

Ian

 

[Marcelo Branco]

That is spot on,
Thank you, it was a simple as that, i was thinking too deep.
Much appreciated

Ian

You are welcome. Thanks for the feedback.

M.