T
Trev
I have a formula setup to count all the entries between a certain date to
count the entries for a project within that date. What I need is to count
the entries that are not equal to the project name. Example in column D I
enter the project name could be Greenbrier, Paramount, Harris Ranch or other
names. I have a formula setup to counting Greenbrier, Paramount and Harris
Ranch separately now and what I need is a counts all of the other entries
that are not equal Greenbrier, Paramount or Harris Ranch.
=IF(AND($N4>=AC$2,$N4<=AD$2),COUNTIF($D4,"Greenbrier"),"")
=IF(AND($N4>=AC$2,$N4<=AD$2),COUNTIF($D4,"Paramount"),"")
=IF(AND($N4>=AC$2,$N4<=AD$2),COUNTIF($D4,"Harris Ranch"),"")
Now I need one to count anything that is not these 3.
Thanks
count the entries for a project within that date. What I need is to count
the entries that are not equal to the project name. Example in column D I
enter the project name could be Greenbrier, Paramount, Harris Ranch or other
names. I have a formula setup to counting Greenbrier, Paramount and Harris
Ranch separately now and what I need is a counts all of the other entries
that are not equal Greenbrier, Paramount or Harris Ranch.
=IF(AND($N4>=AC$2,$N4<=AD$2),COUNTIF($D4,"Greenbrier"),"")
=IF(AND($N4>=AC$2,$N4<=AD$2),COUNTIF($D4,"Paramount"),"")
=IF(AND($N4>=AC$2,$N4<=AD$2),COUNTIF($D4,"Harris Ranch"),"")
Now I need one to count anything that is not these 3.
Thanks