Help using sumif/countif with two conditions

[Hollywoood]

Hi all,

Ive read a few posts on using arrays or others tricks in getting this accomplished but I think one of my conditions may be causing a slight syntax issue that I cannot find.

Below is the latest I've tried without returning the desired result, I will attempt to explain in plain english what it is I am trying to do

=SUM(IF('Data Master'!N:N>=1234,IF('Data Master'!R:R="*"&A2&"*",1,0),0))

My goal is to sum Column N of the sheet Data Master, where the cell value is greater than or equal to 1000 AND where on the same sheet, in the coresponding cell in column R, there exists the Name (the cell could contain several sames separated by a comma) of my summary.

Have to clarify further if Ive made it overly complicated. My two conditions are basically a >= check and a check for the presence of a string of text. Where both are true, I would like to sum

 

[iDeals]

No problem - glad Dcamos was able to get it done for you!

 

[dcamos]

There is no limit, that I have found to the conditions in a sumproduct, I am sure there is one but I have used 5 or 6 before.

 

[T. Valko]

For my own knowledge, is there a limit to the conditions I can place in this manner, for instance if I would like to place a second criteria on the value of the number, a less than condition, would it be as simple as

There is no limit, that I have found to the conditions in a sumproduct, I am sure there is one but I have used 5 or 6 before.

The number of arguments is version dependent.

In Excel 2007 and later you can have up to 255 arguments.

In Excel 2003 and earlier you can have up to 30 arguments.

 

[dcamos]

If you have 255 arguments, doesn't your computer just lock up and not move?

 

[T. Valko]

If you have 255 arguments, doesn't your computer just lock up and not move?

I've never tried it with that many arguments.

Why don't you try it and let us know how you make out?

I'm sure it'll work as long as the ranges aren't too big (less than entire columns).

 

[dcamos]

If I go over 1000 records and 5-6 arguements I get slowed up, would probably die at about 25 arguements, great work computer.