Julia has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Sum if
Hello STL,
I have three columns: in B I specify the country, in C I specify the continent and in D I have values. I want a formula that adds all of the values for Africa. How do I do this? I have tried SumIf but to no avail. I freely concede I may well be inputting the formula incorrectly: I am trying it thus:
SUMIF(D7:D70,C7="Africa")
Can you help?
Thanks,
Julia
RE: 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
RE: Sum if
Hello Gary,
Thanks for your suggestion.
I've tried this and for some reason I can't get it to work.
Could you give me an email address so I can send you a print screen?
Thanks,
Julia
RE: Sum if
Hi Julia
I have attached a workbook with the SUMIF in. I have also given you an example of the Conditional Formatting from your other question.
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
SUMIF and Conditional Formatting.xlsx
