How to count rows with values in two columns

  • Thread starter Thread starter Stapes
  • Start date Start date
S

Stapes

Hi

I want to count the number of rows with Module (Column G) =1 and
Result (Column J) = "Pass".
I tried this:

=COUNTIF('auto test all'!G2:G540,"=1")

which counts the number of rows in Column G = 1. I need them to have
Coulmn J = "Pass" too.

Is there any way I can do this in an excel formula?

Stapes
 
Stapes,

=SUMPRODUCT((G2:G540=1)*(J2:J540="Pass"))

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Back
Top