Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here is what I'm trying to do, I have two colums with data, the first column
will have one of four letters (A, B, C, D) the second column will have one of two numbers (0, 1). I need to get 6 different counts: COUNTIF column A range A1:A250 is A COUNTIF column A is range A1:A250 B COUNTIF column A is range A1:A250 C COUNTIF column A is range A1:A250 D COUNT column A ONLY IF column B range B1:B250 is 0 COUNT column A ONLY IF cloumn B range B1:B250 is 1 I can do the first 4 calculations pretty easy but am having a hard time figuring out how to do the last two calculations. Can anyone help me? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using COUNTIF to check values in multiple columns | Excel Worksheet Functions | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
How do I perform a "Countif" function for Two Columns? | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |