sumif

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » SUMIF

SUMIF

resolvedResolved · Low Priority · Version 2003

Kim has attended:
Excel Intermediate course
Excel Intermediate course

SUMIF

how do you do SUMIF

Edited on Thu 24 Apr 2008, 06:55

RE: SUMIF

Hi Kim, Welcome to the forum, thank you for your post, in answer to your question;
SUMIF adds cells which are specified by criteria which you have set up.
The syntax is; =SUMIF(range to check, criteria, range to sum)
which in terms of a worksheet would be something like =SUMIF(A1:A15,"North",B1:B15) where A1:A5 hold ie the Area Titles, North, South, East and West, where you wish to see a total of figures from the North branch, and these figures are held in the range B1:B15.
Note: if you have a mind to you could name the ranges A1:A15 as "Area" and the range B1:B15 as "Figures" then your formula would be =SUMIF(Area,"North",Figures). The criteria North must be in quotations (") if it is Text. The range Names' do not as once you have created them they are recognised by Excel. I hope that has helped, best regards Pete.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips


Server loaded in 0.07 secs.