countif both conditions in a row of 2 cells exists
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"
|