A
Anthony
I have the current working formula:
{=COUNTIFS(TRIP!$A$2:TRIP!$A$65536,D$16,TRIP!$B$2:TRIP!$B$65536,"<5")}
This works tremendously, however I need to add one more restriction and
can't figure out how to include it. I need to add a:
TRIP!$C$2:TRIP!$C$65536,TRIP!C3<>TRIP!C2
To further specify, here is an example:
TRIP!A TRIP!B TRIP!C D
1 3 4598
1
1 4 1578
1
1 0 1579
1
1 8 3568
1
1 4 8585
1
In this scenario I want to count 4 trips. Trip 1, 2, 3, and 5. My current
formula counts three because it dismisses trip 3 due to the zero value. If I
can put the <> expression in the formula I will eliminate the >0 expression
(as the >0 would automatically dismiss that record anyhow... currently it's
the closest expression I've found to what I actually want).
Thank you!!
{=COUNTIFS(TRIP!$A$2:TRIP!$A$65536,D$16,TRIP!$B$2:TRIP!$B$65536,"<5")}
This works tremendously, however I need to add one more restriction and
can't figure out how to include it. I need to add a:
TRIP!$C$2:TRIP!$C$65536,TRIP!C3<>TRIP!C2
To further specify, here is an example:
TRIP!A TRIP!B TRIP!C D
1 3 4598
1
1 4 1578
1
1 0 1579
1
1 8 3568
1
1 4 8585
1
In this scenario I want to count 4 trips. Trip 1, 2, 3, and 5. My current
formula counts three because it dismisses trip 3 due to the zero value. If I
can put the <> expression in the formula I will eliminate the >0 expression
(as the >0 would automatically dismiss that record anyhow... currently it's
the closest expression I've found to what I actually want).
Thank you!!