Hi!

Are you checking for a specific date OR any date? This will work for ANY
date.

You didn't define what to do if none of the cells has a date so this formula
will leave the cell blank for that condition:

=IF(AND(COUNT(A26,C26),COUNT(F26)),0,IF(COUNT(A26, C26),1,IF(COUNT(F26),0,"")))

Biff

"KBW" wrote in message
...

I'm trying to count/sum the number of rows that have multiple date
entries and based on certain criteria. I've been working with
"Counta", "Sum" & "IF/AND" functions.

Example:
There's a date entry in cells of Column A, C & F. I want to first
check or identify if date is in A or C, then check if there's a date in
F. If both are true, then return "0", if just A or C is true, then
return "1", and if just F is true, then return "0".

This is the latest function I was working with:
{=SUM((IF(A26VALUE("1/1/05")+(C26VALUE("1/1/05")),1)*(F26="")))}

Thx for any help,
Ken


--
KBW
------------------------------------------------------------------------
KBW's Profile:
http://www.excelforum.com/member.php...o&userid=32730
View this thread: http://www.excelforum.com/showthread...hreadid=525663