maybe...

=sumproduct(--(g1:g999<""),--(h1:h999<""))

But this will treat formulas that return "" as "blank".

newbie wrote:

tried a few more times. got it to work. Been looking at this thing too long.
Can I do something similar to just use 2 cells to be counted as a row only
if they are not blank?"

"Dave Peterson" wrote:

Post what you tried.

newbie wrote:

I've tried it. Can't get it to work

"RagDyeR" wrote:

Then just use what Dave posted.

His formula will total over a range.
Follow his instructions to adjust the ranges he used to the ranges you are
using.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"newbie" wrote in message
...
That works Great! Now how could this be done with a range. For example,
looking at each 2 cell row in a range and counting as 1 only if both
condition exist.
G6:G29 <800 and H6:H29=20

"RagDyeR" wrote:

Try this:

=(G6<800)*(H6=20)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"newbie" wrote in message
...
example of what I'm trying to do:
"if the number in G6 is <800 and H6 is =20 then count the row as 1"







--

Dave Peterson


--

Dave Peterson