Requesting for excel formal of combined sumifs+sumproduct+Indirect.

Status
Not open for further replies.

suri7891

New Member
Joined
Dec 24, 2020
Messages
24
Office Version
  1. 2016
Hi Friends,

I am a looking for excel formula for my issue. I need to consolidate data from different sheets into the my consolidate sheet. It has multiple criteria, multiple column sum range, and multiple sheets. It might be combined of Sumifs+sumproduct+Indirect formula for this issue. Because the format is different from one sheet to another.

Please help me.

Regards,
Suresh.K
 

Attachments

  • Consolidate sheet.PNG
    Consolidate sheet.PNG
    26.6 KB · Views: 2
  • Feb sheet.PNG
    Feb sheet.PNG
    28.4 KB · Views: 3
  • Jan sheet.PNG
    Jan sheet.PNG
    25.2 KB · Views: 3
  • Mar sheet.PNG
    Mar sheet.PNG
    27.2 KB · Views: 2

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,214,788
Messages
6,121,603
Members
449,038
Latest member
Arbind kumar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top