Sum IF

Hi Nicholas,

Thank you for the forum question.

The structure for the Sumif is:

=Sumif(Range, Criteria, Sum_Range)

If you in range a2:a100 have let us say months and you in the range b2:b100 have values and you want to sum January the function should look like this:

=Sumif(a2:a100,"January",b2:b100)

The function will then sum each value in the range b2:b100, where January is the month in the range a2:a100.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

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