I have a large set of data on a Sheet{Curr_Data}E6:Q1000, and on another Sheet {Trend} I would like to sum by account, for a particular month or account-CC . Say all account 301001 and for Feb this month and Mar for next month. In 2nd Sheet I would like to have a formula that would be looking to sum all 301001 for Feb based on the second sheet below. Then, when I switch months give me Mar and so on. As you can see some accounts are summarized by account & others by Account-CC. I need a formula that is dynamic with 2nd table I have tried SUMPRODUCT: =SUMPRODUCT((Acct=$B23)*(Mnth=E$20)*Data) Named ranges.
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.