question about SUMPRODUCT
I have a worksheet laid out like this
COLUMN A COLUMN B
manager present
supervisor absent
supervisor present
CEO absent
manager absent
How would I write a formula that would count every "manager" and
"supervisor" present?
thanks.
|