Count the number of Cells in one ROW with conditions

[Guest]

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.

 

[Guest]

=SUMPRODUCT(--(C1:C100="Owner"),--(D1100="Absent"))

 

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

Assuming the data is in rows 2:100, then in D1 put the following
formula

=SUM((C2:C100="owner")*(D2100="absent"))

It's an array formula so you'll need to enter it with CTRL SHIFT and
Enter

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________