CODEWITHSUNDEEP
excelexcel-2007excel-formulaworksheet-function
NewSpeaker
NewSpeaker

Reputation: 67

Using Countifs formula when the data is on different rows

I have a spreadsheet with data about customer rejections, arranged so:

         Col1            Col2            Col3     

Row1   Customer      Rejection Reason

Row2                                    Vendor

What I would like to do is use a COUNTIFS formula to determine which vendors where rejected for which reason. The problem is the vendor is listed on a separate row from the rejection reason so my typical method of using a COUNTIFS formula does not work. Is there some sort of workaround that will prevent me from having to rearrange the data so that everything is on the same row?

I appreciate any help you may be able to provide.

Upvotes: 0

Views: 940

Answers (1)

pnuts
pnuts

Reputation: 59450

Strongly support @Doug's advice but does seem to be feasible with COUNTIFS with current layout, eg: 

=COUNTIFS(C2:C18,"="&D1,B1:B17,"="&E1)

where D1 is the Vendor option and E1 the Rejection Reason option (assuming Col1 is A, etc.)

Upvotes: 1

Related Questions