countif help for multiple criterias

T

tdro

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

Any help would be much appreciated
 
R

RagDyeR

Try this:

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

HTH,

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



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.
 
O

olasa

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="Oranges)+...
...which in this case is equal to Count.

HTH
Ola Sandström
 
Top