Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a formula
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,"Greenbri er"),"") =IF(AND($N4=AC$2,$N4<=AD$2),COUNTIF($D4,"Paramoun t"),"") =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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a formula
Try the below
=IF(AND($N4<"",$N4=AC$2,$N4<=AD$2),ABS(SUM(COUNT IF(C3,{"Greenbrier","Paramount","Harris Ranch"}))-1),"") If this post helps click Yes --------------- Jacob Skaria "Trev" wrote: 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,"Greenbri er"),"") =IF(AND($N4=AC$2,$N4<=AD$2),COUNTIF($D4,"Paramoun t"),"") =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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a formula
cell D4
=IF(AND($N4<"",$N4=AC$2,$N4<=AD$2),ABS(SUM(COUNT IF($D$4,{"Greenbrier","Paramount","Harris Ranch"}))-1),"") If this post helps click Yes --------------- Jacob Skaria "Trev" wrote: 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,"Greenbri er"),"") =IF(AND($N4=AC$2,$N4<=AD$2),COUNTIF($D4,"Paramoun t"),"") =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a formula
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<"Paramou nt")*(D4:D100<"Greenbrier")*(D4:D100<"Harris Ranch")*(D4:D100<"")) Mike "Trev" wrote: 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,"Greenbri er"),"") =IF(AND($N4=AC$2,$N4<=AD$2),COUNTIF($D4,"Paramoun t"),"") =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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|