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
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
