countif multiple criteria

[kylefoley76]

I want to use a countif formula with multiple criteria. What I want to do is count how many times the cells are <>"" so long as b85 = time!$c$2:$c$5000

This is what I'm thinking but I don't know how to use multiple criteria

=COUNTIF(time!$G$2:$G$5000,time!$H$2:$H$5000<>""&b85=time!$c$2:$c$5000)

 

[Andrew Poulsom]

Maybe:

=SUMPRODUCT(--(time!$H$2:$H$5000<>""),--(time!$C$2:$C$5000=B85))

I'm not sure what you want to do with column G.

 

[UniMord]

If you're using Excel 2007 or later, you should use COUNTIFS, which is purpose-built to do exactly what you're trying to do.

Also, it seems to me from your formula, that you might want to use an absolute reference: time!$B$85.

 

[UniMord]

Something like this: =COUNTIFS(time!$G$2:$G$5000,"<>",time!C$2:$C$5000,$B$85)

 

[kylefoley76]

=COUNTIFS(time!$C$2:$C$5000,B80,time!$J$2:$J$5000,time!$J$2:$J$5000<>"")

Ok, I tried the countifs but it isn't working.

I have two criteria, one b80 must equal the c column in time!

then my second criteria column j <>""

if both those are true then i want to count how many times column j is <>""

So far I'm not getting an error message but i'm also getting zero and i shouldn't

 

[kylefoley76]

hold on, i didn't see unimord's suggestion, i think i got it

 

[kylefoley76]

yea, i got it, thanks