counting with multiple criteria

  • Thread starter Thread starter Julz
  • Start date Start date
J

Julz

Good day,

Need the correct formula for the following

If column a contains a number, then count instances when column t=y and
column a>=0.

Thanx,
~Julz
 
Did you enclose the y with quotes "y" ?

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
I've got it working now. Found a couple obvious things. Here's what
I'm using that is working.

=SUMPRODUCT(--(monthopen!$T$4:$T$20013="y"),--(monthopen!$AF$4:$AF$20013>=0))
 
ok, so i'm trying to apply the same logic, which isn't working in this
formula.
=SUMPRODUCT(--(monthclosed!$P$4:$P$20013<=4),--(monthclosed!$AF$4:$AF$20013>=0))
suggestions?
 
I'm wanting to count how many cells in column P <=4 where column AS =>0.
I think I may know part of the problem. All cells in column AS
contain the following string formula,
=IF(OR(AI1=29302,AI1=28751),G1,""), if the forumla is true then the cell
contains a result 1 through 6, if it's not true, then it's blank. Make
sense?
 
If G1 contains an actual number, no, it doesn't make sense. If instead
it contains a text representation of a number, then it does, since
SUMPRODUCT ignores text.


it In article <[email protected]>,
 
Thanx. I think I'll be skipping that one for now. :)

The following formula has me stuck. I'm getting an error saying I have
too few arguments. Any ideas?

=SUMPRODUCT((monthopen!$AF$4:$AF$20013>=0)*(monthopen!$N$4:$N$20013
<16)*(monthopen!$T$4:$T$20013="N"))/COUNTIF(monthopen!$AF$4:$AF$20013>=0)
 
Don't know what you are trying to do but

the countif criteria should be

">=0"


--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Try:

=SUMPRODUCT((monthopen!$AF$4:$AF$20013>=0) * (monthopen!$N$4:$N$20013
<16) * (monthopen!$T$4:$T$20013="N")) /
COUNTIF(monthopen!$AF$4:$AF$20013, ">=0")
 
Back
Top