software

These are my formulas: =COUNTIF(Mo!D853,quot;PMquot;) =COUNTIF(J8:J53,quot;100%quot;)
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 quot;PMquot; and quot;100%quot;, it needs to be both! Help!

Try this:

=SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=quot;100%quot;))

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

Does that help?

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

XL2002, WinXP-Proquot;MANDYquot; wrote:

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

It didn't work, came up #NAME?

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=quot;100%quot;))
gt;
gt; If the values in ColJ are numeric, then you may need to use this:
gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=100%))
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;MANDYquot; wrote:
gt;
gt; gt; These are my formulas: =COUNTIF(Mo!D853,quot;PMquot;) =COUNTIF(J8:J53,quot;100%quot;)
gt; gt; Both formulas work how I want them to separately, but I can't combine them.
gt; gt; I need them to only count if both are true. I need it only to count if it is
gt; gt; a quot;PMquot; and quot;100%quot;, it needs to be both! Help!

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;MANDYquot; gt; wrote in message
...
gt; It didn't work, came up #NAME?
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; Try this:
gt; gt;
gt; gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=quot;100%quot;))
gt; gt;
gt; gt; If the values in ColJ are numeric, then you may need to use this:
gt; gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=100%))
gt; gt;
gt; gt; Does that help?
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;MANDYquot; wrote:
gt; gt;
gt; gt; gt; These are my formulas: =COUNTIF(Mo!D853,quot;PMquot;)
=COUNTIF(J8:J53,quot;100%quot;)
gt; gt; gt; Both formulas work how I want them to separately, but I can't combine
them.
gt; gt; gt; I need them to only count if both are true. I need it only to count if
it is
gt; gt; gt; a quot;PMquot; and quot;100%quot;, it needs to be both! Help!
Yes I did. I've tried just about everything I can think of. Thanks for the
help.

quot;Bob Phillipsquot; wrote:

gt; #NAME sounds unlikely. Did you spell the function correctly?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;MANDYquot; gt; wrote in message
gt; ...
gt; gt; It didn't work, came up #NAME?
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; Try this:
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=quot;100%quot;))
gt; gt; gt;
gt; gt; gt; If the values in ColJ are numeric, then you may need to use this:
gt; gt; gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=100%))
gt; gt; gt;
gt; gt; gt; Does that help?
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;MANDYquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; These are my formulas: =COUNTIF(Mo!D853,quot;PMquot;)
gt; =COUNTIF(J8:J53,quot;100%quot;)
gt; gt; gt; gt; Both formulas work how I want them to separately, but I can't combine
gt; them.
gt; gt; gt; gt; I need them to only count if both are true. I need it only to count if
gt; it is
gt; gt; gt; gt; a quot;PMquot; and quot;100%quot;, it needs to be both! Help!
gt;
gt;
gt;

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

quot;MANDYquot; wrote:

gt; Yes I did. I've tried just about everything I can think of. Thanks for the
gt; help.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; #NAME sounds unlikely. Did you spell the function correctly?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;MANDYquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; It didn't work, came up #NAME?
gt; gt; gt;
gt; gt; gt; quot;Ron Coderrequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Try this:
gt; gt; gt; gt;
gt; gt; gt; gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=quot;100%quot;))
gt; gt; gt; gt;
gt; gt; gt; gt; If the values in ColJ are numeric, then you may need to use this:
gt; gt; gt; gt; =SUMPRODUCT((Mo!D853=quot;PMquot;)*(J8:J53=100%))
gt; gt; gt; gt;
gt; gt; gt; gt; Does that help?
gt; gt; gt; gt;
gt; gt; gt; gt; ***********
gt; gt; gt; gt; Regards,
gt; gt; gt; gt; Ron
gt; gt; gt; gt;
gt; gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;MANDYquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; These are my formulas: =COUNTIF(Mo!D853,quot;PMquot;)
gt; gt; =COUNTIF(J8:J53,quot;100%quot;)
gt; gt; gt; gt; gt; Both formulas work how I want them to separately, but I can't combine
gt; gt; them.
gt; gt; gt; gt; gt; I need them to only count if both are true. I need it only to count if
gt; gt; it is
gt; gt; gt; gt; gt; a quot;PMquot; and quot;100%quot;, it needs to be both! Help!
gt; gt;
gt; gt;
gt; gt;