| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Count the number of Cells in one ROW with conditions
I have a set of data that I need to count the number of cells in Column D.
Here are the conditions, IF Column C contains the word Owner then count the number of cells (in that same row) in Column D that contain the word Absent. |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(C1:C100="Owner"),--(D1:D100="Absent"))
"Amanda" wrote: I have a set of data that I need to count the number of cells in Column D. Here are the conditions, IF Column C contains the word Owner then count the number of cells (in that same row) in Column D that contain the word Absent. |
|
#3
|
|||
|
|||
|
On Fri, 9 Sep 2005 07:23:01 -0700, Amanda
wrote: I have a set of data that I need to count the number of cells in Column D. Here are the conditions, IF Column C contains the word Owner then count the number of cells (in that same row) in Column D that contain the word Absent. Assuming the data is in rows 2:100, then in D1 put the following formula =SUM((C2:C100="owner")*(D2:D100="absent")) It's an array formula so you'll need to enter it with CTRL SHIFT and Enter HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count designated cells | Excel Worksheet Functions | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
Hybrid Mode
