how can i use vlookup and countif to get the results?

If the Report Sheet has the UPI in column A, first row is headers, you can use this formula in column B

=countifs(Group!A:A,A2,Group!C:C,"disable")

in words: in the Group sheet, count all rows where column A has the same word as in cell A2 in this sheet AND the column D has the word “disable”.

Adjust the formula to your scenario and copy down.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top