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
Bookmarks