How do I combine 2 COUNTIF formulas??
It did work!! There was a problem in the spreadsheet, not the formula! Thanks
guys you've been great.
"MANDY" wrote:
Yes I did. I've tried just about everything I can think of. Thanks for the
help.
"Bob Phillips" wrote:
#NAME sounds unlikely. Did you spell the function correctly?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"MANDY" wrote in message
...
It didn't work, came up #NAME?
"Ron Coderre" wrote:
Try this:
=SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53="100%"))
If the values in ColJ are numeric, then you may need to use this:
=SUMPRODUCT((Mo!D8:D53="PM")*(J8:J53=100%))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"MANDY" wrote:
These are my formulas: =COUNTIF(Mo!D8:D53,"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!
|