View Single Post
  #1   Report Post  
nmc1104
 
Posts: n/a
Default 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.