Count the number of Cells in one ROW with conditions

A

Amanda

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.
 
R

Richard Buttrey

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.
Click to expand...


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
__________________________
 
Top