Is there any way to merge these two formulas?
=COUNTIF(Active!$A$2:$A$426,"*construction*")
=SUMPRODUCT((Active!$G$2:$G$426>=11)*(Active!$G$2:$G$426<=20))
Is there any way to merge these two formulas?
=COUNTIF(Active!$A$2:$A$426,"*construction*")
=SUMPRODUCT((Active!$G$2:$G$426>=11)*(Active!$G$2:$G$426<=20))
Last edited by NBVC; 12-20-2010 at 04:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks