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
__________________________