Sound Science

Comment from jonathan92591
Time December 22, 2011 at 10:06 am

Such a great lesson! Thank you!

Comment from regal033
Time December 22, 2011 at 11:01 am

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

Comment from VideoGameRoom32
Time December 22, 2011 at 11:53 am

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.

Comment from raycolondotcom
Time December 22, 2011 at 12:32 pm

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

Comment from cesterx
Time December 22, 2011 at 12:36 pm

Jako dobro, kratko i korisno. Bravo!!!

Comment from MsNJohnson
Time December 22, 2011 at 1:26 pm

another great video!!!!

Comment from shikha0085
Time December 22, 2011 at 2:25 pm

good 

Comment from raycolondotcom
Time December 22, 2011 at 2:57 pm

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

Comment from raycolondotcom
Time December 22, 2011 at 3:17 pm

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

Comment from raycolondotcom
Time December 22, 2011 at 3:23 pm

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

Comment from PHILZ82
Time December 22, 2011 at 4:01 pm

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

Comment from MegaRumano
Time December 22, 2011 at 4:48 pm

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

Comment from Mjb111999
Time December 22, 2011 at 5:08 pm

thank you very much!!

Comment from raycolondotcom
Time December 22, 2011 at 5:34 pm

@AndyIsBack94 Hi Andy, you’re welcome.
Thanks for letting me know that this video helped you. Ray

Comment from AndyIsBack94
Time December 22, 2011 at 6:29 pm

Thank you so much ^.^

Comment from raycolondotcom
Time December 22, 2011 at 7:23 pm

@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

Comment from LoniHart
Time December 22, 2011 at 7:26 pm

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

Comment from raycolondotcom
Time December 22, 2011 at 7:59 pm

@hydrofal78 You’re welcome, Balam.

Comment from hydrofal78
Time December 22, 2011 at 8:15 pm

thank you

Comment from raycolondotcom
Time December 22, 2011 at 8:34 pm

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

Comment from jhunlap
Time December 22, 2011 at 8:58 pm

THANX. IT HELP ME A LOT ON MY WORK.

Comment from raycolondotcom
Time December 22, 2011 at 8:59 pm

@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

Comment from sehej
Time December 22, 2011 at 9:06 pm

very nicely explained. helped a lot. thanks

Comment from raycolondotcom
Time December 22, 2011 at 9:47 pm

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

Comment from killadrag0n
Time December 22, 2011 at 10:17 pm

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