Thread: [Solved] If column A contains X and Column B contains Y then total how many
View Single Post
 
Old 04-19-2017, 04:10 AM
jwallace90 jwallace90 is offline Windows 8 Office 2007
Novice
  
Join Date: Apr 2017
Posts: 3
jwallace90 is on a distinguished road
Default If column A contains X and Column B contains Y then total how many
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
Reply With Quote