If column A contains X and Column B contains Y then total how many

		Microsoft Office Forums > Microsoft Excel > Excel
If column A contains X and Column B contains Y then total how many

FAQ

Mark Forums Read

Thread Tools

Display Modes

04-19-2017, 04:10 AM

jwallace90 jwallace90 is offline

If column A contains X and Column B contains Y then total how many

Windows 8

Office 2007

Novice

Join Date: Apr 2017

Posts: 3

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Read multiple xml files in excel - Column names and Tag - Column alignment	sumshen	Excel Programming	0	04-17-2017 12:55 AM
Query total column	Forums10	Office	1	06-07-2015 04:08 AM
How to obtain a column total using only specific cells	Jo Freeman	Excel	3	03-20-2015 06:18 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
Want a quotient using a constant to show up in column c each time a number is added to column b	fibbermcghee	Excel	2	12-09-2014 05:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:18 AM.