Comments on: Most useful Excel functions with formula examples

This page can be your entry point to learning Microsoft Excel functions. It lists the most essential text, math, statistical, logical and other functions along with formula examples and links to related resources. Continue reading →

Comments page 2. Total comments: 46

  1. very very nice i hope a very help me

  2. how to use countif formula

  3. Hi....
    how to fill alphabat a to z such as we fill the number without any formula.?

  4. Hi,

    How to covert number (2,3,4,5..) to word.

    Please do the needful.

  5. Hai, in a conditional formula some result is arrived from a range. How to extract only such details from the range which is suiting the conditional formula.

    thanks

  6. IN EXCEL SHEET I HAVE ENTERED THE MARKS , NOW FROM THAT MARKS I WANT TO FIND OUT HOW MANY NUMBER OF VALUES GREATER THAN OR EQUAL TO 22(>=)

    1. Hello VARSHAN,

      You can use the following COUNTIF formula: =COUNTIF(A:A, ">=22")

  7. Thanks very muych for providing very useful information.

  8. Hi Svetlana,

    im made macro , but when i Run the macro it will take too much time to give me the output
    im using Application.screenupdating =False this code but still macro speed was not gone up

    could tell me which code i have to use for speed.

    Regards,

    Vishu shinde.

  9. I have entered 3 quadrans with different plant underneath, how do I get the Simpsons index arrggg :-( please

  10. can I count instead of sum in (=SUMIF(A1:A5, "apples",B1:B5)) formula, If yes tell me how please.

    1. Hi Narinder,

      Just use the COUNTIF function instead of SUMIF. For example, the following formula counts how many "apples" are in range A1:A5.

      =COUNTIF(A1:A5, "apples")

  11. can i count instead of sum.

  12. Dear Mam,

    I had fixed assets list comprising of different items related to different projects, since the project names are repetitive as whenever the fixed asset has been assigned to that particular project. Now i want to sum-up all these figures for respective project on line wise basis.Supppse project A has come 15 times during the transactions so its difficult for me to sum them up by identifying every single item cost.

  13. Hi Svetlana
    , Thank you for sharing some awesome stuff! I hope you you can guide me in what I am trying to do.
    I am trying to tie Multiply drop down lists (Data dependency) with (I hope) simple IF function so that based on multiply answers in dependency loop I can copy/paste automatically predefined answers from another sheet. Those answers are usually Product list.
    Example: I have 10 products (first drop down), that can be packaged or not (2nd drop down). If packaged, I would than give option
    of 2-3 package options (design etc). Based on those, I want to conveniently copy table with description to current sheet (from sheet next to that one).This is meant to be introductory sales document.
    I could use Macro, but I don't have much experience.
    Thoughts!?
    Thank you.

    1. Hello, Dragan,

      I suggest using the VLOOKUP(D3, Answers!D3:E7, 2) function to insert text from another sheet. So after you select a product from the Drop-down list to cell D3, the text from the Answers sheet will automatically appear in your current table.

  14. Hi,
    I have read through several different articles looking for an answer to my problem, got lots of great tips but nothing defiant that helps me now.
    Could you please help me on this? I’m trying to create a formula that adds the total amount for a particular supplier that is more than 30 days & in another cell a formula that is more than 60 days, etc…
    I have the dates of invoices in column A, supplier’s names in column B and Total value in column C.
    Any help would be appreciated, have spent days on this & to no avail. Thanks

    1. Hello, Kay,

      For us to be able to help you better, please send us a small sample table with your data in Excel and include the expected result. You can email the details to support@ablebits.com

  15. Respected Mam,

    if sum formula is anywhere in excel sheet then result of formula should not exceed 27.500.

    pl. help

  16. how to write logical command - figure not more than 3 and must be more than 0

  17. Thank you for your useful information
    God bless you inshaallah

  18. how can be part of the blog. to ask questions or give tips. can I do it? there is any fee involve?

    1. Hi Leah,

      You are welcome to post your questions or any other feedback in comments, and if we know the answer we will be happy to help. And, it's absolutely free :)

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)