Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sumifs between date

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sumifs Between 2 Date Ranges From a Pivot Table

Sumifs Between 2 Date Ranges From a Pivot Table

ResolvedVersion 2016

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

RE: Sumifs Between 2 Date Ranges From a Pivot Table

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

RE: Sumifs Between 2 Date Ranges From a Pivot Table

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

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

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.