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.