And Statement

[Guest]

I've looked at the below statement too many times and I can't figure out why
it won't work. I've tried using AND as well. I have 10 regions broken out
by west, central, and east. I need it to pull all the regions I specify and
count the number of wins. What appears to be happening is that it only pulls
in the wins for the first region listed, North East and doesn't count the
remaining.

=(Sum(IIf([Status]="wins" And [Region]="north east" Or "new england" Or
"Great Lakes" Or "North East",1,0)))

I've tried the below as well but no luck:
=(Sum(IIf([Status]="wins" And [Region]="north east" And [Region]= "new
england" And [Region]= "Great Lakes" And [Region]= "North East",1,0)))

I hate to post questions but I do give it my best try before coming to you
all. I admit I have some trouble with the complicated formulas. Thanks for
your time and help!

 

[Guest]

Try this

=Sum(IIf([Status]="wins" And ([Region]="north east" Or "new england" Or
"Great Lakes" Or "North East"),1,0))

 

[Guest]

It appears that it adds anything with a status of "wins" but doesn't test for
region. B/c I get a total of 19 (and that happens to be the total of all 10
regions) not just the ones specified below. Any more ideas? Thanks! I am
still trying as well.

Try this

=Sum(IIf([Status]="wins" And ([Region]="north east" Or "new england" Or
"Great Lakes" Or "North East"),1,0))

--
In God We Trust - Everything Else We Test

I've looked at the below statement too many times and I can't figure out why
it won't work. I've tried using AND as well. I have 10 regions broken out
by west, central, and east. I need it to pull all the regions I specify and
count the number of wins. What appears to be happening is that it only pulls
in the wins for the first region listed, North East and doesn't count the
remaining.

=(Sum(IIf([Status]="wins" And [Region]="north east" Or "new england" Or
"Great Lakes" Or "North East",1,0)))

I've tried the below as well but no luck:
=(Sum(IIf([Status]="wins" And [Region]="north east" And [Region]= "new
england" And [Region]= "Great Lakes" And [Region]= "North East",1,0)))

I hate to post questions but I do give it my best try before coming to you
all. I admit I have some trouble with the complicated formulas. Thanks for
your time and help!

 

[Duane Hookom]

Won't work that way either.

=Sum(IIf([Status]="wins" And ([Region]="north east" Or [Region]="new
england" Or [Region]="Great Lakes" Or [Region]="North East"),1,0))
or possibly
=Sum(IIf([Status]="wins" And [Region] IN ("north east","new england","Great
Lakes", "North East"),1,0))

--
Duane Hookom
MS Access MVP
--

Try this

=Sum(IIf([Status]="wins" And ([Region]="north east" Or "new england" Or
"Great Lakes" Or "North East"),1,0))

--
In God We Trust - Everything Else We Test

I've looked at the below statement too many times and I can't figure out
why
it won't work. I've tried using AND as well. I have 10 regions broken
out
by west, central, and east. I need it to pull all the regions I specify
and
count the number of wins. What appears to be happening is that it only
pulls
in the wins for the first region listed, North East and doesn't count the
remaining.

=(Sum(IIf([Status]="wins" And [Region]="north east" Or "new england" Or
"Great Lakes" Or "North East",1,0)))

I've tried the below as well but no luck:
=(Sum(IIf([Status]="wins" And [Region]="north east" And [Region]= "new
england" And [Region]= "Great Lakes" And [Region]= "North East",1,0)))

I hate to post questions but I do give it my best try before coming to
you
all. I admit I have some trouble with the complicated formulas. Thanks
for
your time and help!

 

[Guest]

Thanks - I tried the first one and it worked!

Won't work that way either.

=Sum(IIf([Status]="wins" And ([Region]="north east" Or [Region]="new
england" Or [Region]="Great Lakes" Or [Region]="North East"),1,0))
or possibly
=Sum(IIf([Status]="wins" And [Region] IN ("north east","new england","Great
Lakes", "North East"),1,0))

--
Duane Hookom
MS Access MVP
--

Try this

=Sum(IIf([Status]="wins" And ([Region]="north east" Or "new england" Or
"Great Lakes" Or "North East"),1,0))

--
In God We Trust - Everything Else We Test

I've looked at the below statement too many times and I can't figure out
why
it won't work. I've tried using AND as well. I have 10 regions broken
out
by west, central, and east. I need it to pull all the regions I specify
and
count the number of wins. What appears to be happening is that it only
pulls
in the wins for the first region listed, North East and doesn't count the
remaining.

=(Sum(IIf([Status]="wins" And [Region]="north east" Or "new england" Or
"Great Lakes" Or "North East",1,0)))

I've tried the below as well but no luck:
=(Sum(IIf([Status]="wins" And [Region]="north east" And [Region]= "new
england" And [Region]= "Great Lakes" And [Region]= "North East",1,0)))

I hate to post questions but I do give it my best try before coming to
you
all. I admit I have some trouble with the complicated formulas. Thanks
for
your time and help!