Sort by time | Sort by thread (beta)

Link to this comment:

Share to:
see all

All Comments (33)

Sign In or Sign Up now to post a comment!

  • THANKS A EFFING MIL, Been struggling whole day at work to be able to do this and its so simple...

    coke491 1 week ago

  • @coke491 , I am glad that the vid helped!

    ExcelIsFun 1 week ago

  • NO WAY!!!!! hahahahahahahahhaha.... ;)

    ShineMetallicaDown 3 weeks ago

  • Funny tone of explaining...its like you're talking to a baby!!! :D anyway, NICE ONE!!! ;)

    ShineMetallicaDown 3 weeks ago

  • video is great but that voice makes it hard to watch

    kpeaches726 3 months ago

  • dude you are brill you have given me a anwser to a formula that i have been wanting for weeks

    gunnerate 6 months ago

  • EXCELlent!! 

    ExcelIsFun 6 months ago

  • many thanks - sweet explanation :p

    SunnyHeirReborn3 10 months ago

  • I am glad that you liked it!

    ExcelIsFun 10 months ago 2

  • very informative and enthusiastic!

    pureassyrian1 10 months ago

  • I am glad that you like it!

    ExcelIsFun 10 months ago

  • This is first class tutorial! Very helpful THANKS!

    biffo28 11 months ago

  • You are welcome! I am glad that they help.

    ExcelIsFun 11 months ago

  • you are amazing! keep up the good work

    CoEEzi 1 year ago

  • I am glad it helped!

    ExcelIsFun 1 year ago

  • you are amazing!

    CoEEzi 1 year ago

  • I am glad it helped!

    ExcelIsFun 1 year ago

  • Can I use COUNTIF if I have my ranges named on another worksheet?

    Mehalick311 1 year ago

  • Yes you can!

    ExcelIsFun 1 year ago

  • Oh My Goodness! Your upload helped me! hehe. many many thanks!

    EchosSilver 1 year ago

  • You are welcome!

    ExcelIsFun 1 year ago

  • Hey great tips. I wanted to ask a question. When i type a sum in a column it sometimes nears it to the nearest pound, how do i stop it doing this!? thanks

    shaneyspatch 1 year ago

  • Try increasing the decimals. See if that works. If it does not, comment back with more detail.

    ExcelIsFun 1 year ago

  • Great video! Can you place a boolean function in the formula so that it will pick more then one sales rep? i.e. counting every Chin or Suix??

    Theoldncranky 1 year ago

  • To count every Chin or Suix use this formula:

    =COUNTIF(Sales_Rep,"Suix")+COU­NTIF(Sales_Rep,"Chin")

    to add:

    =SUMIF(Sales_Rep,"Suix",Sales)­+SUMIF(Sales_Rep,"Chin",Sales)

    ExcelIsFun 1 year ago

  • Million Thanx to you man!!! Awsome job done, u r a true genius, ur way of explaining things is also marvelous.........

    Hats Off...

    gaurhari 1 year ago

  • You are welcome! I am glad that video is helpful!

    ExcelIsFun 1 year ago

  • Giid job .. its very usefull.

    tkns

    ranjan1961 2 years ago

  • You are welcome!

    ExcelIsFun 2 years ago

  • You're very enthusiastic and quite knowledgeable. Thanks for the video, very helpful material.

    limbo55 3 years ago

  • Dear limbo55,

    No Problem! I am happy to provide useful tips!

    If you keep watching and rating, I'll keep making useful videos!!

    --ExcelIsFun

    ExcelIsFun 3 years ago

  • @ExcelIsFun .. how do I go about down loading the file/video. thanks

    sareze1 4 months ago

  • @sareze1 , I do not know how to download video, but the Excel file can be downloaded here:

    people.highline.edu/mgirvin/Ex­celIsFun.htm

    ExcelIsFun 4 months ago

View all Comments »
Loading...
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more