Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - What is the sumif functions?
Resolved · Low Priority · Version Standard
Katherine has attended:
Excel Advanced course
What is the sumif function?
Hi Katherine, thanks for the post; the SUMIF function is used to total information in a list subject to certain criteria, for example from a list of sales branches, you can stipulate that you only require to total a particular branch's sales figures and using the SUMIF function it will return a total as per your criteria. The layout would be as follows: =SUMIF(range, criteria, sum_range) - which would be: (range of cells to inspect, criteria (name of branch in quotes " ") and the range of cells to find those totals in.
hope that helps
regards
Pete
|
Excel tip:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |
We'll call during UK business hours
Server loaded in 0.12 secs.