Formulas

Resolved · Medium Priority · Version 2016

Thu 29 Aug 2019, 12:16 Delegate Angela said...

Angela has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course

Formulas

If I wanted to do the following:
To add up all the figures that are in particular column but only the ones that have a specific month within their date. E.g Give me the total of all the figures that relate to Jul 2019

Thu 29 Aug 2019, 23:06 Trainer Jens said...

RE: Formulas

Hi Angela,

Thank you for the forum question.

If you have the dates in the range A2:A100 and the values in the range C2:C100 the formula to sum all values for July 2019 should be:

=Sumproduct((Year(A2:A100)=2019)*(Month(A2:A100)=7),C2:C100)

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Thu 5 Sep 2019: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips