Sumifs Between 2 Date Ranges From a Pivot Table | Excel forum

Resolved · Medium Priority · Version 2016

Mon 1 Mar 2021, 14:27 Sam Ryder (guest) said...

Sumifs Between 2 Date Ranges From a Pivot Table

Hi,

Sheet "Account Data"

I need to sum Column C "FD Count" & Column H "FD Count" between dates => 1/2/202 & <= 2/14/2021.

Can the formula be put in "Sheet 1" Column AI Row 1

Thanks,

Sam

Mon 1 Mar 2021, 14:33 Sam Ryder (guest) said...

RE: Sumifs Between 2 Date Ranges From a Pivot Table

Just realised I can't attach a file is there a way to?

Tue 2 Mar 2021, 16:06 Sam Ryder (guest) said...

RE: Sumifs Between 2 Date Ranges From a Pivot Table

Hi It has been over 24 hours and still no repsonse?

Wed 3 Mar 2021, 10:45 Trainer Richard said...

RE: Sumifs Between 2 Date Ranges From a Pivot Table

Hi Sam,

Thank you for your question and following up with a contact request. It's unusual your question didn't pop but it looks like you replied to your own question so that made it appear as answered. Please accept my apologises for the delay in spotting this.

Please email Info@STL-training.co.uk the Excel file so we can assist in answering your question

We look forward to your email Sam

Kind regards

Richard Bailey
Microsoft Certified Trainer

STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips