SUM SUMIF COUNT COUNTIF - Excel for Business - Lesson 3

[jimaster93]

Thank you for sharing your knowledge with us! 

[raycolondotcom]

@jimaster93 You're welcome. Glad you found it helpful.

[JocaBrate94]

thanks so much dude

[jonathan92591]

Such a great lesson! Thank you!

[regal033]

Brilliant!! I was looking for how to do a "countif" statement. You explained it very well. Thanks!

[VideoGameRoom32]

Great video. What if I have a range from L3 to L26 has sum and the total amount should be on L28. IF L3 to L10 have an amount but L11 to L26 says "N/A" How do I get it to add up the numbers and ignore the N/A to get the total amount in L28. Thanks. Because right now L28 is not adding up the total amount if there are N/A the L cells.

[cesterx]

Jako dobro, kratko i korisno. Bravo!!!

[raycolondotcom]

@cesterx Hvala Vam. Drago mi je pomoći. (via Google Translate)  :)

[MsNJohnson]

another great video!!!!

[shikha0085]

good

[PHILZ82]

the guy who is givin the voice sounds like an italian mob boss!!!!!! no offence loved it

[raycolondotcom]

@PHILZ82 LOL, thanks for the laugh, PhilZ. Now I'll have to make you an offer you can't refuse. :) Ray

[MegaRumano]

Thanks a lot, sum if was just the function I was looking for GREAT VIDEO!!!

[raycolondotcom]

@MegaRumano Thanks for letting me know that the video helped you, MegaRumano. You're welcome. Ray

[Mjb111999]

thank you very much!!

[raycolondotcom]

@Mjb111999 You're welcome, Mjb. Glad I could help. Ray

[AndyIsBack94]

Thank you so much ^.^

[raycolondotcom]

@AndyIsBack94 Hi Andy, you're welcome.

Thanks for letting me know that this video helped you. Ray

[LoniHart]

Thanks for sharing on how to use count if in excel. I cannot get it to count the following properties with ocean view. If I put count if a2a12,Ocean it only yields one? and work around? OCEAN

Ocean View,Water View

Marina View,Ocean View,Panoramic View,Water View

Canyon View,Hills View

Coastline View,Hills View,Ocean View,Panoramic View,View,Water View,White Water View

Catalina Island View,Ocean View,Water View,White Water View

Coastline View,Ocean View,Water View

[raycolondotcom]

@LoniHart Hi Loni. As long as there is only one instance of "ocean" in each cell, as in your example, the following should work for you. Include "*" before and after the word you are looking for like this: =COUNTIF(A2:A12,"*ocean*").

Ray

[hydrofal78]

thank you

[raycolondotcom]

@hydrofal78 You're welcome, Balam.

[jhunlap]

THANX. IT HELP ME A LOT ON MY WORK.

[raycolondotcom]

@jhunlap Thank you, jhunlap. I'm glad that this video was helpful to you. Ray

[sehej]

very nicely explained. helped a lot. thanks

[raycolondotcom]

@sehej Hi sehej, thanks for your comment. You may be interested in visiting my excel web site that I relaunched yesterday. I've changed my approach in that I am posting shorter tutorials. "One minute videos for bite-sized learning." I'm working my way through the basic topics and will expand to longer videos when I cover more complicated material. Excel4BusinessOnline [dot] com Ray

[killadrag0n]

Thanks, helped me on my excel assignment! =] Thumb'd up!

[raycolondotcom]

@killadrag0n Hi SliCk_XP. I'm glad that this video helped you with your excel assignment. Thanks for letting me know. Ray

[TurtleCrickNick]

Fantastic Training Video. Short, Sweet & VERY Effective!

[raycolondotcom]

@TurtleCrickNick Hi Nick, thanks for letting me know that this video was helpful to you. I appreciate the input. Ray

[shichochino]

thank you so much!..you're such a big help..thank you..really glad that I saw your tutorial :]

[raycolondotcom]

@shichochino Hi and you're welcome. Yours was the first comment that I saw this morning, so the day is off to a good start. :) Glad I could help. Ray

[MIMISIMI17]

Thank you, thank you, THANK YOU!

[raycolondotcom]

@MIMISIMI17 Hi Sarah, thanks for letting me know that the video was helpful. You're welcome. Ray

[Mafia2786]

I want my "SUMIF" formula to calculate a total from two columns eg. column B2:B70 and C2:C70 I tried the following =SUMIF(A2:A70,"Alex",B2:C70) but this only gives me the total of the first column B2:B70 and ignores C2:C70 ... Please Help =(

[raycolondotcom]

Hello, for some reason your question was marked as spam, so I didn't see it until now.

For what you are trying to do, you should use the following:

=SUMPRODUCT((A2:A70="Alex")*B2­:C70)

Make sure that there are no text items in your sum range and this should work. Ray

[loverpeace33]

Thanks Alot

[raycolondotcom]

Hi loverpeace33, you're welcome. I hope the video was helpful. :) Ray

[enaziai]

many thanks

[raycolondotcom]

My pleasure. Thanks for commenting. Ray

[parth123halani]

hey thanx... Raycolon itzzz awesome and itzz goin to help me for my exams

[raycolondotcom]

Thanks for the feedback. I'm glad that I could help. If you're interested, newer Excel tutorials can be found on my other YouTube channel: Excel4Business. Good luck with your exams! Ray

[Minat0Y0ndaime]

im making a sreadsheet for my A level ICT project.. i have 3 invoices on seperate worksheets and a stocklist. i need to count how many of each order there are then take that away from my stock level but i cant think how to do this could u give some advice.. i think u need to use the sumif unction but im not sure..

[Guilddude2]

One of the best presentations on Sum if - and shown in real life type situations.

Thanks!

[raycolondotcom]

Hi Guiddude, thank you for your kind comment. I had intended to video more Excel lessons, but wondered if the one's I've already posted were proving to be useful to viewers. I appreciate the feedback. Ray