Presentation Transcript
COUNTIFS FUNCTION :COUNTIFS FUNCTION www.bluepecan.co.uk
Excel Training www.bluepecan.co.uk
Slide 2:www.bluepecan.co.uk This function is like the COUNTIF function but it allows you to add more than one set of criteria for your count.
Slide 3:www.bluepecan.co.uk Here is an example: I want to count the number of deposit accounts that are held in the Brighton branch. This is how I would do it:
Slide 4:www.bluepecan.co.uk First of all I’ll click into the cell where I want the formula to go, then…
I’ll click on Insert function button on the formula bar – it’s the button with fx on it.
Then I’ll search for the COUNTIFS function
Slide 5:www.bluepecan.co.uk I’ve now got to express my first criteria – the fact that I’m only interested in accounts held in Brighton Criteria_range1 is the Branch column: A2:A21
Criteria1 is Brighton
Slide 6:www.bluepecan.co.uk Criterai_range2 is the Account Type column C2:C21
Criteria2 is Deposit Now I’ve got a second set of boxes to fill in to express the additional criteria: the fact that I only want to count deposit accounts.
Slide 7:www.bluepecan.co.uk I’m now finished, so I’ll click on OK. The answer I got was 2. There are two deposit accounts held at the Brighton branch.
COUNTIFS FUNCTION :COUNTIFS FUNCTION www.bluepecan.co.uk
Excel Training www.bluepecan.co.uk