Need Consolidation from sheet 1 to sheet 2

[maddyrafi1987]

I want to display total output in numbers in sheet2 from the sheet 1 input

[AliGW]

Please provide expected results (manually added) for the first 10-15 rows of the results table.

[maddyrafi1987]

we should not add manually in sheet2. we need to put formula in sheet2 and it should display the output total numbers that how how much total numbers are there in the given region1 and region 2 in the specific product type given

[AliGW]

Precisely, so show us what you are expecting, then we can offer a formula.

You really should understand how this works by now!

[maddyrafi1987]

i have attached sample output here. i need the output in all cell it will bring from formula

[Olly]

You could use a COUNTIFS formula, something like:

=COUNTIFS(Data!$H$2:$H$2503,$C4,Data!$I$2:$I$2503,$D4,Data!$P$2:$P$2503,E$3)

The problem with this is that you must manually maintain the row / column headers, to make sure all Regions and Product Types are included.

Much better to use a pivot table. See attached example.

[maddyrafi1987]

it works nice but i attached one more column, can you pls fill the same and send

[Olly]

You can make that change yourself. Select the pivot table, and in the Field List, drag field "branch name" into the ROWS section.

[maddyrafi1987]

i don't know pivot table so pls in MIS2 sheet F4 = what formula i want to put?

[Olly]

You don't know the formula, either. So, given you need to learn SOMETHING, I suggest learning the pivot table.