How do I combine 2 COUNTIF formulas??

[Guest]

These are my formulas: =COUNTIF(Mo!D853,"PM") =COUNTIF(J8:J53,"100%")
Both formulas work how I want them to separately, but I can't combine them.
I need them to only count if both are true. I need it only to count if it is
a "PM" and "100%", it needs to be both! Help!

 

[Guest]

Try this:

=SUMPRODUCT((Mo!D853="PM")*(J8:J53="100%"))

If the values in ColJ are numeric, then you may need to use this:
=SUMPRODUCT((Mo!D853="PM")*(J8:J53=100%))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Guest]

It didn't work, came up #NAME?

Try this:

=SUMPRODUCT((Mo!D853="PM")*(J8:J53="100%"))

If the values in ColJ are numeric, then you may need to use this:
=SUMPRODUCT((Mo!D853="PM")*(J8:J53=100%))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Bob Phillips]

#NAME sounds unlikely. Did you spell the function correctly?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Yes I did. I've tried just about everything I can think of. Thanks for the
help.

 

[Guest]

It did work!! There was a problem in the spreadsheet, not the formula! Thanks
guys you've been great.