LinkBack URL
About LinkBacks
I want to display total output in numbers in sheet2 from the sheet 1 input
I want to display total output in numbers in sheet2 from the sheet 1 input
Please provide expected results (manually added) for the first 10-15 rows of the results table.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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
Precisely, so show us what you are expecting, then we can offer a formula.
You really should understand how this works by now!
i have attached sample output here. i need the output in all cell it will bring from formula
You could use a COUNTIFS formula, something like:
Formula:
Please Login or Register to view this content.
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.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
it works nice but i attached one more column, can you pls fill the same and send
You can make that change yourself. Select the pivot table, and in the Field List, drag field "branch name" into the ROWS section.
i don't know pivot table so pls in MIS2 sheet F4 = what formula i want to put?
You don't know the formula, either. So, given you need to learn SOMETHING, I suggest learning the pivot table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks