Help with a formula

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
 
J

Jacob Skaria

Try the below

=IF(AND($N4<>"",$N4>=AC$2,$N4<=AD$2),ABS(SUM(COUNTIF(C3,{"Greenbrier","Paramount","Harris Ranch"}))-1),"")

If this post helps click Yes
 
J

Jacob Skaria

cell D4

=IF(AND($N4<>"",$N4>=AC$2,$N4<=AD$2),ABS(SUM(COUNTIF($D$4,{"Greenbrier","Paramount","Harris Ranch"}))-1),"")

If this post helps click Yes
 
M

Mike H

Trev

You formula isn't doing whay you say it is. After evaluating the 2 dates
it's then only looking at a single cell D4. If you post a small sample of
data then I'm sure someong will give you a formula or are you trying to do
this

SUMPRODUCT((N4>=AC2)*(N4<=AD2)*(D4:D100="Paramount"))

and to count cells that aren't any of the 3

=SUMPRODUCT((N4>=AC2)*(N4<=AD2)*(D4:D100<>"Paramount")*(D4:D100<>"Greenbrier")*(D4:D100<>"Harris Ranch")*(D4:D100<>""))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top