Two criteria for CountIf?
=SUMPRODUCT(--(A1:A3<"closed"),--(NOT(ISBLANK(B1:B3))))
replace A1:A3 and B1:B3 with the appropriate ranges
DB_Bill wrote:
I have two columns of cells that need to be evaluated and determine if the
criteria are met in order to be included in a count. The first column needs
to have something other than "Closed" and the second column and row should
contain something other than null/blank. Is there a simple way to include
both criteria in a single statement to allow a count of the rows?
|