countif help for multiple criterias
 

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" wrote in message
...

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

Is this what you want? If not, give an example
=SUMPRODUCT((A1:A10="Apples")*(D1:D10="Oranges"))
Sums (A1="Apples)*(D1="Oranges)+(A2="Apples)*(D2="Orang es)+...
...which in this case is equal to Count.

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=379031