(Solved) Adding multiple COUNTIFS that contains multiple sheets

Hi All,

To simplify, I have 3 sheets. The sheet contains: column A = Dealer #/ Column B= Total unsatisfied customer's which is where i put my formula. It is to count how many YES' the dealer# in column A received.

The data are in sheet 2 and sheet 3, each representing a different month. But we don't care about time frame, we just want total. Too much data to combine. Sheets 2 and 3 data are displayed like: Column A = Dealer # / Column B = Did a customer complain?(yes or no)

I know if I want to calculate only from sheet 2, but on sheet 1 cell b1, formula would be.... =COUNTIFS('sheet 2'!A:A,'sheet 1'!A1,'sheet 2'!C:C,"yes")

Now how do I add =COUNTIFS('sheet 2'!A:A,'sheet 1'!A1,'sheet 2'!C:C,"yes") + =COUNTIFS('sheet 3'!A:A,'sheet 1'!A1,'sheet 3'!C:C,"yes") in to one formula?? Thank you very much in advance.


example. sheets 2 and 3 are like the back sheet. Front sheet is my data sheet that need the formula.
Attachment 417047

str8_6,

Welcome to the Forum. As a newcomer you may not be aware that the preferred upload is an Excel workbook with appropriate data to your question. Pics / screen shots are often difficult to read and nobody wants to retype data.

To attach a workbook click Go Advanced at the bottom of the reply window. At the bottom of the screen you will find Manage Attachments. Click that and starting at the top of the dialogue window the steps pretty much explain themselves.

BTW Please be sure to desensitize the data.

This might be simpler. With the sheet names listed in R1:R2 array-enter this formula in B2 and fill down.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

This formula reflects querying Sheet1 and Sheet2. Since the layout of Sheet3 was different than the others I assumed you meant those sheets. This formula depends upon data in each sheet being in identical ranges.

Does this help?

Been there ... done that.