countif help for multiple criterias

Try this:

=SUMPRODUCT((A1:A100="Apples")*(D1:D100="Oranges"))
--

HTH,

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


"tdro" <[email protected]> wrote in message
news:[email protected]...

I am try to set a formula to get a count based on two cells. Basically
the formula should read If column A = "Apples" and column D = "Oranges"
then count it. When I nest the formulas, it does not consirer both
conditions. As long as one condition matches, it counts it.

Any help would be much appreciated.


--
tdro
------------------------------------------------------------------------
tdro's Profile: http://www.msusenet.com/member.php?userid=2199
View this thread: http://www.msusenet.com/t-1870535240

I am try to set a formula to get a count based on two cells. Basically
the formula should read If column A = "Apples" and column D = "Oranges"
then count it. When I nest the formulas, it does not consirer both
conditions. As long as one condition matches, it counts it.

Any help would be much appreciated.


--
tdro
------------------------------------------------------------------------
tdro's Profile: http://www.msusenet.com/member.php?userid=2199
View this thread: http://www.msusenet.com/t-1870535240

Try this:

=SUMPRODUCT((A1:A100="Apples")*(D1:D100="Oranges"))
--

HTH,

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


"tdro" <[email protected]> wrote in message
news:[email protected]...

I am try to set a formula to get a count based on two cells. Basically
the formula should read If column A = "Apples" and column D = "Oranges"
then count it. When I nest the formulas, it does not consirer both
conditions. As long as one condition matches, it counts it.

Any help would be much appreciated.


--
tdro
------------------------------------------------------------------------
tdro's Profile: http://www.msusenet.com/member.php?userid=2199
View this thread: http://www.msusenet.com/t-1870535240