Social
"My latest blog article on Fimodo http://bit.ly/8ZrZeR"
Who is Plum?
Based in Sydney, Australia, Plum Solutions has been providing professional financial modelling solutions since 2004.Read more...
I have attended a Financial Modelling course with Danielle in Kuala Lumpur and I would like to seek your help on SUMIF function.
How do I use SUMIF, should I have 2 criterias to fulfil?
I have attached a copy of some data for illustration.
Let's say I have Criteria 1 : Alor Setar; and Criteria 2 : MONTH
How do I go about it?
Thanks.
Regards,
Mandy
"My latest blog article on Fimodo http://bit.ly/8ZrZeR"
Based in Sydney, Australia, Plum Solutions has been providing professional financial modelling solutions since 2004.
Of course, I remember you. Hope all is going well with your modelling!
SUMIF doesn’t handle two sets of criteria very well, but there is a work-around. There is a way of using a SUMIF to pickup multiple criteria by using the ampersand (&) in the criteria. You need to create an additional column which adds the two criteria together. You should be able to do exactly the same thing but with three criteria.
If column D contained a formula such as =A3&B3, the formula would look something like this: =SUMIF(D3:D22,F4&G4,C3:C22)
Alternatively, if you are using Excel 2007, you will be able to use a SUMIFS (as opposed to a SUMIF) formula - a MUCH easier way of doing it, as this allows for multiple criteria in a SUMIF.
I hope this makes sense, and you should be able to apply the same principles to your own model!
Submitted by danielle on Thu, 09/07/2009 - 17:00.
Post new comment