Sum if

Hi Julia

Thanks for getting in touch. Your formula is nearly correct but there is an optional argument you need to use, the [sum range].

The first argument is where you are going to search for criteria, the second is the criteria to SUM by, and the third is which cells to sum based on the criteria. They are adjacent to the search. In your example, it would look like:

=SUMIF(C7:C70,"Africa",D7:D70)

This is searching for "Africa" in the range C7:C70. Whenever an "Africa" is found, it SUMs the value found in the same row.

I hope this helps.

Kind regards

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