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