Sum If / Or

B

Brandi

I am trying to count a text field in my database based on quite a few
different things.

I want to count [Priority] when it equals "1 - Impacting" AND [Status]
euqlas "Assigned" OR "Accepted" OR "Designing" OR "Researching" OR "On Hold"
-Or we can...-
Count [Priority] when it equals "1 -Impacting" AND [Status] does NOT equal
"Closed - No Action" OR "Closed - Production"

I have tried:
=Abs(Sum([Priority="1 - Impacting" AND ([Status]="Assigned" OR
[Status]="Accepted" OR [Status]="Designing" OR [Status]="Researching' OR
[Status]="On Hold")))

=Abs(Sum([Priority="1 - Impacting" AND ([Status]="Assigned" OR ="Accepted"
OR ="Designing" OR ="Researching' OR ="On Hold")))

=Abs(Sum([Priority="1 - Impacting" AND ([Status]="Assigned" OR "Accepted" OR
"Designing" OR "Researching' OR "On Hold")))

=Abs(Sum([Priority="1 - Impacting" AND ([Status]<>"Closed - No Action" OR
[Status]<> "Closed-Production"))

None of these have worked. Any ideas would be appreciated.
 

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

Similar Threads

Displaying zeros in a report? 2
Help? I need help in making formulas work to accomplish... 0
Fun with SUMPRODUCT 14
Multi-level GROUP BY 8
Creatng If Statements with several groups 7
adding different columns in a cross tab report 3
if it is null how not to get the #error 1
I would like to only sum the fields which equal a criteria that fall within a certian date. 4

Top