TamaraNewcombe Posts: 2, Reputation: 1 New Member #1 Mar 11, 2008, 10:11 AM
Counting when there are 2 criteria
In a spreadsheet, how do I get a count total if there are two criteria? For example, in one column I want to count all the "1"'s if, in another column there is a "c".
 ScottGem Posts: 64,966, Reputation: 6056 Computer Expert and Renaissance Man #2 Mar 11, 2008, 10:13 AM
Read up in Excel Help on Microsoft Query. You can use ths feature to do more complex queries of your data.

 Question Tools Search this Question Search this Question: Advanced Search

## Check out some similar questions!

Counting Items [ 1 Answers ]

If a variable in column A fulfills a certain condition, I have it listed in column B Column A Q W E R T

Counting technique [ 1 Answers ]

I found that a circle placed in a rectangle can be shaded in 4 different ways. First, don't shade anything. Second, shading the circle only. Third, shading the rectangle only. Fourth, shading both the circle and rectangle. The question is: Find the number of shadings possible for 2 circles in a...

Counting blank cells with multiple criteria [ 1 Answers ]

Hello, I need some help with counting blank cells. Here's my data: Name Feb 07 Roger x Lisa Bob x Lisa Lisa x Lisa

Counting to a million [ 1 Answers ]

How long would it take an average person to count to one million if they had 8 hours a day to do the counting.

Counting Cells If several criteria are true [ 1 Answers ]

Another question. I'd like to count the number of cells in column C that have "incorrect" in them, if the corresponding cells in column A have "people" in it, and column B has "intact" in it. So if A = people and B = intact, count all C that = incorrect. Thanks!