Hi,

I am looking for some help please.

I have rows of data on a excel sheet and i am looking to total these up using formulas.

I would like to know how many Red Cars that are 5 door there are and in the 3rd colum put the total count.

For example.

Red 5


Blue 2
Red 5
Red 5
Green 2

Then the answer in my other box would be 3

can you tell me if this is possible please

thank you

Hi
have a look at the COUNTIFS function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

great thank you