=SUM(IF(Repurchase_Tracking_Table!$B$2:$B$2308=A15 ,IF(Repurchase_Tracking_Table!$U$2:$U$2308="Final
Deny",1,0),0))+SUM(IF(Repurchase_Tracking_Table!$B $2:$B$2308=A15,IF(Repurchase_Tracking_Table!$U$2:$ U$2308="Loss
Mit
Deny",1,0),0))+SUM(IF(Repurchase_Tracking_Table!$B $2:$B$2308=A15,IF(Repurchase_Tracking_Table!$U$2:$ U$2308="",IF(Repurchase_Tracking_Table!$K$2:$K$230 8="Final
Deny",1,0),0)))+SUM(IF(Repurchase_Tracking_Table!$ B$2:$B$2308=A15,IF(Repurchase_Tracking_Table!$U$2: $U$2308="",IF(Repurchase_Tracking_Table!$K$2:$K$23 08="Loss Mit Deny",1,0),0)))

This one's a mess, Ron....thanks for looking. I definitely need to make
this one a little more streamlined.

Regards,
Marty

"Ron Coderre" wrote:

If you post your formula, we'll see what you're working with.


Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)



"martinbarnes" wrote in message
...
Ron,

That was very helpful...thanks. Unfortunately, it's not working because
when i nest/insert the "COUNTIF" into my "IF" formula, I'm getting double
the
number. Is there another way to do it when it's inside an IF formula?

I should probably be figuring this out myself but my brain is mushed out.

"Ron Coderre" wrote:

With a list of items in A1:A20

This formula returns the count of cells that contain Criteria1 or
Criteria2:
B1: =SUM(COUNTIF(A1:A20,{"Criteria1","Criteria2"}))

or...you could reference a list...
C1: Criteria1
C2: Criteria2
B1: =SUMPRODUCT(COUNTIF(A1:A20,C1:C2))

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"martinbarnes" wrote in message
...
Can anyone help me with this? i'm trying to incorporate the OR
function
with
a COUNTIF function