Need assistance adding data based on date range

[sm370]

I'm trying to calculate the following from the attached sample:
Current Month Sent
Previous Month Sent
YTD Sent

[Jonmo1]

Current month
=SUMIFS(Sheet1!$C2:$CQ2,Sheet1!$C$1:$CQ$1,">"&EOMONTH(TODAY(),-1),Sheet1!$C$1:$CQ$1,"<="&EOMONTH(TODAY(),0))

Previous month
=SUMIFS(Sheet1!$C2:$CQ2,Sheet1!$C$1:$CQ$1,">"&EOMONTH(TODAY(),-2),Sheet1!$C$1:$CQ$1,"<="&EOMONTH(TODAY(),-1))

YTD (assuming ALL data on Sheet1 is YTD..)
=SUM(Sheet1!$C2:$CQ2)

[sm370]

How would I add these formulas into the list on sheet2? My actual data has over 700 accounts with data going back to beginning of 2016. I can tweek the formulas to adjust for the full data set, just confused on incorporating into list of accts on sheet2. Thanks

[oeldere]

With VBA code to rearange the data.

After that a pivot table (and add the month in the table).

See the attached file.

[sm370]

Unfortunately, I am not familiar with the use of Pivot tables and am unsure how to go about setting up.

[oeldere]

Then learn about pivot table, since it is a very powerfull tools which is expanded every new version of Excel.

I suppose that is the way Microsoft tells us, that is the way to go.