Count cells w/values in column if the data in column a matchescri
Try this:
=SUMPRODUCT((A1:A100=D1)*(B1:B100<""))
where D1 contains the criteria.
Hope this helps.
Pete
On Jan 11, 8:29*pm, mdcgpw wrote:
I need a formula that counts the number of cell that contain data in column B
as long as the corresponding cell in column A matches a given criteria.
|