PDA

View Full Version : Count of distributors based on criteria



arnab0711
06-04-2012, 03:41 AM
Hi,
I want the formula in row 3 of snap shot sheet
In textTotal distributors in the month of April
logic will be --
count of all distributors where Zone(column G of details sheet) = "North"
and Active/non Active(column H)=Active

Bob Phillips
06-04-2012, 08:07 AM
Haven't we done this one two or three times before?

CatDaddy
06-04-2012, 08:09 AM
=SUMPRODUCT(--(G:G="North"),--(H:H="Active"))