Excel Tutorial – SUMIF function

Today I show you how to use SUMIF to analyse your data. Ever needed to add things together based on category? Have two columns but only want the total of column two where x = “something”? This is for you. Works in Excel 2003 and Excel 2007
Video Tutorial Rating: 4 / 5

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 3,621 views

10 responses to “Excel Tutorial – SUMIF function”

1. humblecuzz says:

   01/01/2013 at 8:12 pm

   yeah very helpful and clear i needed a simple example to understand the formula and this did it

   Reply
2. Musa Salami says:

   01/01/2013 at 9:11 pm

   Great work. i appreciate your effort, this unlock my understanding at first sight.

   Reply
3. Ret Wit says:

   01/01/2013 at 9:19 pm

   Thanks Nick..its nice hearing another Aussie and wow I just learnt how to SUM IF !!!!!!!!!!
   

   Reply
4. ownerpk3058 says:

   01/01/2013 at 9:38 pm

   Thanks that was great!

   Reply
5. normanlucasjr says:

   01/01/2013 at 10:17 pm

   got my igcse ict mocks coming up and this was really useful!!! thanks!!

   Reply
6. alexis española-agana says:

   01/01/2013 at 10:46 pm

   sorry, your voice is too slang I can’t understand some of the words you say, it seems to me that you murmuring something.

   Reply
7. RyanJoe501 says:

   01/01/2013 at 11:44 pm

   Heartfelt thanks!!

   Reply
8. Ileddie says:

   01/01/2013 at 11:56 pm

   Oh shit, my houn size is at an all time high thanks to this video. HOUN SIZE PULLETH!

   Reply
9. k0kizzle says:

   02/01/2013 at 12:44 am

   Very helpful ! Many thanks !!!

   Reply
10. dandyrocket says:

    02/01/2013 at 1:44 am

    OMG, thank you so much for posting this video. It really helped me 😀

    Reply