Ask Experts Questions for FREE Help !
    TamaraNewcombe's Avatar
    TamaraNewcombe Posts: 2, Reputation: 1
    New Member

    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man

    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.

Not your question? Ask your question View similar questions


Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.

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!

View more questions Search