Comments on: Google Sheets IF function - usage and formula examples

Get to know Google Sheets IF function better with this tutorial: when it's used, how it works and how it contributes to a much simpler data processing. Formula examples are included! Continue reading →

Comments page 2. Total comments: 607

  1. I'm looking to move answers from one sheet to another only if the question matches. So IF cell A matches cell B then move the answer over from cell C to cell D. But the questions might be in an whole column so I'd want it to check the whole column.

  2. I am trying to build a formula where if there are ANY numbers put in column E there is yes put in B, but if E is blank there is nothing in B

    1. Hello steph,

      Try this formula (change the ranges to yours):
      =ARRAYFORMULA(IFERROR(IFS(ISNUMBER(A1:A10),"ENTER_NUMBER",A1:A10="",""),""))

  3. I am trying to build an if formula. Column B has total net Rev, Column C $ per work order.
    In column E I am looking for if $ per work order 44.99 and net rev>$500 it will multiply by .13
    Column I should be if $ per work order is >64.99 and Net Rev>$500 it will multiply by .15

    Also I would like it to say $0 if in colum G and I did not match the criteria

    1. Hello Daniel,

      It looks like you need the AND criteria in your IF function. I explained it here. To build the formula with numbers correctly, please also look at the examples here.

  4. I am trying to sum the total of a column of if statements. Each cell in the column is as follows: =if(G61>0,"1","")
    I am trying to add the total of the produced column but can not seem to come up with a formula that will add this column up. I am guessing it is because Google sheets is using the results not as a number value. Any help would be appreciated. Their are 77 rows in the column and about 50 have a value of one but it is not totaling that.

  5. Is it possible to use the IF function for something like this: If the cell contains a sentence without a punctuation mark, that part of the cell will be removed?

  6. Hello, Im looking for a formula to calculate billable hours at different rates for different customers and it all depends on if its a billable service, and I'm not sure if the IF function is correct. my example is i need to bill customer A $50.00 per hour based on input hours if a check box is checked true and customer b $60.00 per hour again if check box is true, but leave the cell blank if the check box is false. Let me know if you can help.

    1. Hello Stephen,

      If I understand your task correctly, IF will solve it. To see if the box is checked, you can literally use TRUE/FALSE:
      =IF(A2=TRUE,...,...)

      To leave the cell blank if FALSE (not checked), use a pair of double quotes like in the Tip here, step 2.

  7. How do i create an if statement that achieves the following.

    1. I have 1000 named accounts each with a unique physical address information.

    2 I would like to build a sheet where if an account name was input in a row in column A then column B of that same row will auto populate the correct address that corresponds with the account. This rule continues in the following rows below.

  8. HI,

    I am trying to create a formula that would put a specific amount when 3 different drop downs are in place...

    I have 3 drop downs : 1st drop down is union or non-union, 2nd drop down is dancer, assistant, choreographer, and 3rd drop down is full day or half day.

    I would like it to generate a cost depending on whichever array of drop down is in play... example: if I have union, assistant, and half day that would equal $1 or if I have non-union, dancer, full day that would equal $2 , and so forth.

    please help, ive been working on this for days to no avail. Thanks :)

    1. Hi YESENIA,

      The IF function from this article is perfect for the job. Have you tried using it for your formula?

  9. This seems like it should be an easy function. Every combo of formulas even with the formula builder won't grab the data I'm looking for. I have two sheets I'm working in. I'm trying to pull data from another sheet (JanExp) based on column criteria. My column criteria is "subscriptions". I want the value in Column E based on if its criteria is "subscriptions". The formula it's giving me seems to work, but it just gives me a blank value even when a number is present in column E, but it isn't giving me an error saying my formula is invalid.

    =IF(JanExp!C1 = "Subscriptions", JanExp!D1, )

    1. Ha- GOT IT!! I figured it out. I needed a SUMIF in front of it. I knew it didn't seem that difficult. Thanks for the great reference point to get me started!

      =SUMIF(JanExp!C:C,"Subscriptions",JanExp!D:D)

  10. I have three columns in Google Sheets:
    Column P = Effective Date
    Column Q = End Date
    Column R = Days Remaining in Term

    In Column R, I want to show the number of days between the End Date (Column Q) and today's date. If Column Q is blank, I want the corresponding cell in Column R to be blank. If Column Q is a date in the past, or less than today's date, I want the corresponding cell in Column R to show "Past Due".

    Currently, I am using this formula: =if(and(isdate(P37),isdate(Q37)),DATEDIF(Sheet2!$A$1,Q:Q,"D"),) and it is working for the first two scenarios, however, I can't figure out how to account for the third scenario, when the cell should say "Past Due".

    1. Hello Trystan,

      I'm sorry, I've got a bit confused by the Sheet2!A1 (does it contain the TODAY function?) and with the logic of the 'Past Due' label if the end date was before today's (it isn't past due then, is it?). Hence, for me to be able to help you better, please consider sharing an editable copy of your spreadsheet with us (support@apps4gs.com) including your formula.
      Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

      I'll look into it and try to help.

  11. hi i'm trying to use your examples with the following:
    column a (a drop down menu with three options)
    column b (numbers)

    I'm trying to create an if function that will calculate total of column B IF column a has a certain menu option.
    my formula is not working: =SUMIF((a10:B50="Foundation"),(b10:b50))

  12. Team, I am calculating whether employees have earned an hour of acrued hours based on hours worked. When they work at least 37 hours a week, they earn an hour of sick time up to 40 hours for the year. I created and if/and formula that populates a 1(representing an hour) or 0 if they have not worked 37 hours. In addition, once they reach forty hours of sick time and acrue 40 hours of sick time, the formula will stop acruing hours. I created an if/and statement in each of the cells. I need to total the # of YTD hours acrued. I have not been successful in finding the appropriate way to sum the column. I am assuming that is because of the formula in each of the cells.

    How can I sum a column of cells that have #'s achieved with an if/and formula.

    1. Hi Linda,
      Can you give me the formula you used ? This is exactly what I need. Thank you in advance for any help!
      Joanne

      1. Hi Natalia,
        Any help with Linda's formula? I am trying to do the same thing using a column when an employee hits 30 hours.

        Thank you!

        1. Hi Joanne,

          I suggested Linda to try SUMIFS to tally time based on the condition provided. I'm unable to provide a formula since I don't have all the details necessary and don't know how the data is arranged. Have you seen this function?

  13. I am trying to create a simple function in a Google Sheet whereby a cell (D10) checks another cell (B10) for specific text (Hotel or Apartment)

    If it finds the text 'Hotel, it populates 'D10' with the content of 'E5', however if it finds the text 'Apartment', it populates 'D10' with the content of 'E6'

    This then needs to be repeated for the next 6 rows accordingly

    See screenshot https://prnt.sc/J8y9CPNTDuk5

    It seems like a very simple command but I am struggling to get it to work

    Any help would be greatly appreciated

  14. Hello! I'm trying to allocate a value to a reference with the "IF" formula, but it doesn't seem to work. To explain a bit further, I'm building a spreadsheet to help me calculate costs for dinners. I have a column with a list with 2 items. Based on the item selected (Menu 1 or Menu 2) I would like the next column to automatically add the allocated cost.

    For example, if I select Menu 1 in my column, I'd like the price to appear in the next column automatically.

    So far, I tried this one =IF(C3="Menu 1","39.50","49.50")

  15. Hello,
    I am trying to execute an if statement that will add up all the hours of an individual worker. I have a sheet where individual projects are recorded, with the date, the names of the workers who participated in the project and the hours they worked on the project. I would like the if statement to sum up all the values ​​in the hours column if there is an individual employee's name in the second column.
    I wrote the statement like this, but it doesn't work, it returns FALSE and I can't find a reason why it doesn't return sum of the hours.

    =IF(Gora!E2:E="Name of the worker";SUM(Gora!C2:C))

    Gora is the name of the sheet that contains information about the projects, since I do the totals of hours on another sheet.
    I can easily create such if statements in Excel, so I hope that they can also be used in Google Sheets.

    Thank you for your answer, Maša

  16. writing a macro and want to test for a number or blank cell, cant find a function. "ISNUMBER()" does not seem to work in a macro and I cant find the equivalent in the macro.

  17. Column A = 10,000
    In Column B, if column A is equal or less than 90,000 then the value in column B must be the value in A
    in Column B, if column A is greater than 90,000 then the value in column B must 90,000

  18. Hi,
    What to do if I want this scenario:
    Column A = 10,000

    in Column B = If column A is = 90,000, the value in column B must 90,000

  19. Hello,

    I'm making a budget spreadsheet and in column D I have spending categories, and in column E I want it to auto populate with Essential or Non-Essential based on the text in col. D. Example: "Groceries" and "Debt Payments" would be essential while everything else is non essential. I've tried variations of the IF THEN formula laid out above and read through all of the comments but in every variation of the formula I keep getting errors. So far I've only got two versions of this formula to work but it only has one spending category from col D included.

    =IF(D3="Debt Payments","Essential")

    =IF(D2="Debt Payments","Essential","Non Essential")

    To include more spending categories such as groceries, I've tried this:

    =IF((D4="Groceries","Essential");(D4="Debt Payments","Essential"))

    This formula says a parse error. I've also tried

    =IF(OR(D4="Groceries","Essential");(D4="Debt Payments","Essential")) and the same error happens. The same happens when I tried this

    =IF((D4="Groceries","Essential","Non Essential"),(D4="Debt Payments","Essential","Non Essential"))

    If I can't have col E populate and note that all other spending categories are non essential thats fine.

    Thank you in advance for your help!

    1. I've tried this formula on multiple lines of the spreadsheet, thats why the cell number kept changing above.

      1. Figured it out

        =IF(OR(D3="Debt Payments", D3="Groceries", D3="Mortgage"), "Essential","Non Essential")

  20. Hi there

    I need a formula:

    If A1 is blank, doesn't allow B2 to enter a value.

    Thanks in advance

    1. Hi Shafiq,

      You need to use Data validation for this.
      Go to Data > Data validation. As a cell range, pick B2. As a criteria – the following custom formula: =A1<>""
      Pick Reject input on invalid data and hit Save.

      1. Thank you for your kind help dear Natalia.
        I really appreciate it.

  21. Thank you so much for this article! It's just what I was looking for.

    Is there a way to set a condition for if one cell contains certain text, then the number in the cell next to it (on the same row) is populated into a 3rd cell. I'm trying to sort a list of transactions into their budgeted buckets. Column A is the expense amount, Column B is which bucket the expense is budgeted in. I want to format other cells so that whenever Column B says "Bucket 1" the dollar value in Column A of that same row is inserted into these cells.

    Thank you!

    1. Hello Dean,

      Thanks for the feedback!

      If I understand your task correctly, you need to put he formula into your 3rd cell saying:
      =IF(B2="Bucket",A2,"")

      At the end of this part of the article, you'll find a way to process the entire column with one formula at once.

      1. Thank you for the response!

  22. I am trying to combine a number from one cell, and some text into a second cell. For example, B2 has the number 6, and then I want B3 to say "6 out of 10". How do I get it to take the value from B2 and then add the "out of 10"?

  23. Hi,
    Thanks for the information. Your articles are all so helpful. I have a question. How do I do an IF statement for if a number is within a certain range. Let's say A1 may have any number from 0 to 20, and I need a formula that has one result based on the value in A1 being from 0 to 4, another result on 5-11, and another on 12-20. I'd rather not have to write out nested IF statements for every value from 0 to 20.

  24. Hello!

    If amount in each row is more than 10, the points should be added 1000 for each row. How to use formula in google sheet?

    Example;
    Row 1 col 1=10 attendance, row 2 col 2=45 attendance, row 3 col 3=25 attendance. The points to auto calculate should be 3000 points. how to auto calculate this? because sometimes the attendance could be lower than 10 which no points for it.

  25. This was so helpful. I spent most of my day searching how to do something and you had the answer. You guys are awesome !!

  26. Hello! I am currently trying to create a formula that will pull names from column C on a sheet titled Comm Log who have 3 numbers below 60 in 3 different columns. I have started with: =IF(Comm Log!M3<60,Comm Log!C3,"") but I am pretty stumped. Any help would be appreciated!

    Thank you!

    1. Hello Carl,

      If I understand your task correctly, you need to incorporate the AND function to your IF formula. It will look at 3 different columns for the required number at the same time.

      You can also try our IF Formula Builder add-on. It lets you enter your conditions the user-friendly way and will gather everything into a formula for you.

  27. guys, i'm not that technical to this but i can get a few things done...

    i'm trying to get say,

    column

    if
    column A is 1 and B is 1 then C is value of money, say £100 and then
    which means i can also mate it
    if A is 0 and B is 1 then C is £50

    is there a way to give value to 1 and to 0 and maybe 2 ?

    and what could be the best formula for it ?

  28. How to use below functions in google sheet

    1. =IF(Values_Entered,-PMT(Interest_Rate/12,Loan_Years*12,Loan_Amount),"")
    2.=IF(Values_Entered,Loan_Years*12,"")
    3.=IF(Values_Entered,Number_of_Payments,"")
    4=IF(Values_Entered,SUMIF(Beg_Bal,">0",Extra_Pay),"")
    5=IF(Values_Entered,SUMIF(Beg_Bal,">0",Int),"")
    6=IF(Values_Entered,1,"")
    7=IF(Values_Entered,Loan_Amount,"")
    8=IF(Pay_Num"",Scheduled_Monthly_Payment,"")
    9=IF(Pay_Num"",Scheduled_Extra_Payments,"")
    10=IF(Pay_Num"",Sched_Pay+Extra_Pay,"")
    11=IF(Pay_Num"",Total_Pay-Int,"")
    12=IF(Pay_Num"",Beg_Bal*Interest_Rate/12,"")
    13=IF(Pay_Num"",Beg_Bal-Princ,"")

    1. Hello Praba,

      I'm not sure I understand your question. Do you get any errors when entering these formulas to your Google sheet?

  29. Hi,
    I can't work out which function(s) I need!
    I want to create a pie chart that collates percentages by category. I have books listed by genre, with their page count as a percentage of the total page count of all the books in the sheet. How do I group the percentages by genre to make a pie chart?
    E.g.
    Genre (Fantasy), % of total pages 6.21%
    Genre (Fantasy), % of total pages 4.62%

    How would I get a pie chart to show "Genre (Fantasy), 10.83%"?

    I thought I would need to use the IF function to get it to add up the percentages but I'm really unsure. Any advice would be amazing!!

    1. Hi Leeza,

      Yoy may want to check these special blog posts for the solution:
      Google Sheets percentage formulas
      How to make a Pie Chart in a Google spreadsheet

      If you're still unsure how to prepare the data and make the chart, for me to be able to help you better, please share a small sample spreadsheet with us – support@apps4gs.com – with 2 sheets: (1) a copy of your source data (2) the result you expect to get. I kindly ask you to shorten the tables to 10-20 rows.

      Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

      I'll do my best to help you.

    2. Oops, I meant to add- I've tried using the SUMIF function (=SUMIF(e3:e999, ”fantasy”, h3:h999)) but I get an error.

  30. I am trying to highlight the rest of the columns once I checked the checkbox. Is that an IF function?

    Thanks in advance!

  31. Hello!
    I'm trying to use a "simple" IF-function, but if the value is "false" I want the cell to remain empty. Or is their a better function for this?

    The values in the cells is "JA" or "NEJ". If "JA" = Recycle, IF "NEJ" = nothing.
    "=IF(L14="JA";"Recycle")"

      1. Thank you so much! You saved my day =)

  32. Hi can you help me, I am using the following two "IF" functions.
    IF(F21=24, 0%, 18% )
    IF(F21=24, 9%, )

    If I enter "the F21 cell" value manually it works. But if I automate the value of "the F21 cell", let's just say I fill "the F21 cell" with help of the VLOOKUP function or data validation, then "the IF function" is not working at all. Please enlighten me about my mistake.

    1. Hi Vasav,

      I'm not sure what's happening on your side, everything works as expected on mine.

      For me to be able to help you, please consider sharing your problem spreadsheet with us: support@apps4gs.com
      Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

      I'll try to help.

      1. As per your instruction, I have shared the Sheet with a given account. For instruction plz refer to Raw 51. I have tried to explain the problem and also showed you result I am expecting.

        1. Thank you for sharing your spreadsheet, Vasav.

          All your numbers in the TIN column in the Statewise GSTIN Code sheet appear as text. Hence, your VLOOKUP in F21 returns text values. But the conditions in your IF formulas are for numbers, that's why they don't work. Because F21 contains text.

          Change records in the TIN column to numbers and everything should work correctly then.

  33. Im trying to add 60.00 to string when the answer is True under PCR Test but the string wont add. The rest is adding correctly. Thanks in advance.

    =if(E2>14,E2*7,if(E214,E2*7,if(E2<14,P1+100,if(H2="True",P1*60)+(F2*2)+(G2*5))) (Nothing adds or formulates) ?

    1. Hello Shawn,

      Please consider sharing an editable copy of your spreadsheet with us: support@apps4gs.com. Please include a sheet with the result you expect to get (the result sheet is of great importance and often gives us a better understanding than any text description). I kindly ask you to shorten the tables to 10-20 rows.

      Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

      I'll look into it.

  34. Good Day!

    This is such an awesome elucidated If-Function usage! I would like to ask if would it be possible to combine this IF-fucunction and the CHAR (=CHAR) function such as 10004 and 10008?

    For example, if the If statement is true, the cell will yield =CHAR(10004). Else its=CHAR(10008)

    Thank you very much!

      1. Wow! Thank you!

  35. Hello

    I want multiple cells with text in all to equal 1 and then be added together eg

    Cell 1. Cell 2. Cell 3 Cell4
    g. a z. 3

    Are you able to help?

    thanks

    Wayne

    1. Hello Wayne,

      I'm sorry but your task is not clear to me. Please describe it in detail and provide some examples of the data you have and want to get.

  36. Greetings,

    I'm trying to evaluate if a cell has a specific string, then run the REGEXEXTRACT() function to get everything after the string as the TRUE return value, else for the FALSE return value just return the value of the cell itself:

    =IF(SEARCH(“~”, D2) > 0, REGEXEXTRACT(D2,".*~(.*)"), D2)

    This just gives me an error. Is there a way to do this in Google Sheets? Seems a simple thing.

    1. I will say that the REGEXEXTRACT is working just fine IF the tilde (~) is present. Otherwise, it returns #N/A

      1. Hi Jonathan,

        You're getting #N/A because SEARCH still return 1 for some reason and REGEXEXTRACT don't see matches for your regular expression. As Google Docs for SEARCH suggests, it's recommended to use something like IFERROR to check for cases when there aren't matches to the search. So your formula need to look like this:
        =IFERROR(IF(SEARCH("~", D2)>0,REGEXEXTRACT(D2,".*~(.*)")),D2)

  37. Hi. We have to build a spreadsheet on google sheet to track sales invoices with invoice amount, paid amount, outstanding balance stating the status if it is already past due or if it is a current amount. thank you.

    1. Hi,

      Well it sounds like the IF function from this article will do for your task. Have you already tried it?

  38. I would like to enter a number and have a functioning formula that subs a percentage from same cell's input and gives an output in the same cell

    1. Hello Amalia,

      I'm afraid you can't enter formulas into the same cells that you're referring to with the formulas themselves. Google Sheets just doesn't work this way. You will have to enter formulas in another column.

  39. I was trying to link the IF function to a cell with a drop down. The goal is to get the cell with the IF function to display the corresponding price for an item when selected from the dropdown.

    It didn't seem to work when I tried the formula in multiple formats. Any help would be appreciated.

    1. Hello Tyler,

      Please provide the exact formula you're trying to use.
      Also, please specify what you mean by "formula in multiple formats".

  40. Help would be appreciated! I have min/max level of inventory that I have to maintain and I have an Inventory sheet and an order sheet. I want the Order Sheet to pull data from the Inventory Sheet if the on hand number is equal to or lower than the minimum level that is set for that item.

    I know I will need to =FILTER('Inventory Sheet'!$A$2:$G$784,???

    TIA

  41. Hello
    I want to know if it is possible an IF Function in Google Sheets in the following way -

    I have an excel file with Project Topics corresponding with numbers counted 1 to 40 that are completely anonymous to all the students. I want to apply an IF function in such a way that - once a student enters a number from 1 to 40 in the Google Sheet, the Project Topic corresponding with that number in my excel file be displayed in a separate column in the Google Sheet.

    This way I can assign Projects, assignments and everything randomly to the students so that they dont feel like I am being biased towards any students while doing so. Another way by which it can help me is that sometimes students start fighting with each other over topics if I let them choose topics on their own out of the list.

    I think it will help a lot of other teachers as well if u can solve this problem. Thanks alot !

    1. I forgot to mention a couple of things if u are wondering about it.
      1. If students enter the same Number between 1 to 40 more than once, I dont have a problem in that coz Students must themselves see that the number is already taken up by someone.
      2. All the Students must be able to see the topics that have been assigned on basis of this Google Sheet and my Excel Sheet.

  42. Hello,
    My "If" formula is only checking the line where is it writted.
    Ex: I write in A1 "=IF(A5="plop", "good", "bad")" It works, because A1 and A5 are in the same line
    But if I write in A1 "=IF(B5="plop", "good", "bad")" it affiche me #VALUES!

    Any help? thank you

    1. Hello Jozzy,

      IF doesn't really care where it's written. In your case, I'd recommend looking at B5 – what does it contain? If you hover your mouse over the #VALUE! error in A1, what does it say?

  43. =if(B12>800, sum(b12 to G12), if (B12<800, sum(E12 TO G12)))

    I encountered something like above formula. I reproduced above from recollection and cannot refer back to that file.

    The only point I want to ask is if B12 has only text, should not the result of above formula be an error?

    Why the result is a number which is addition of E12 TO G12.

    Thanks

    1. Hello Prav,

      You get the result as a second calculation because any number (even negative) in Google Sheets is less than the letter 'a'. I can't say why it works this way but you can check that by simply trying and comparing 'a' to '-10,000', for instance. That's why you'd better use numbers in cells where the logic for your formulas requires numbers.

      If you think this shouldn't work this way, you can leave feedback to the Google Sheets team directly (Help - Help Sheets improve via the menu).

  44. is it possible if formula builder without google sheet

  45. hi,
    i wanted to write a formula for if a certain cell is not blank then it will show a hyperlink but if not it will remain blank

    i tried making my own formula

    =IF(ISBLANK(A2),=HYPERLINK("https://api.whatsapp.com/send?phone="&A9&"&text="&B9,"send whatsapp msg"),)

    is there in changes or alternative to implement?

    1. Hi Dhruv,

      You messed with a syntax a bit, here's a correct formula:
      =IF(ISBLANK(A2),HYPERLINK("https://api.whatsapp.com/send?phone="&A9&"&text="&B9),"send whatsapp msg")

  46. Hey! I'm struggling to work out how to write an IF equation which I feel is super basic! I'm wondering if anyone could help me out?

    All I'm wanting is for a cell to turn red if the input is either above 0.3 or below 0.3. Eg: 5.8 = green, 6.1 = red.. It seems like it would be so basic but my attempts have failed

  47. HI can you help pls, I have sheet of overtime : col A with names, col B dates, col C start time, col D end time, Col E (D-C) total hours worked on single entry in HH:MM, Col F overtime rate (either 10% or 20%).
    Names may be repeated as it's a daily list over a month, so may total 30+ rows listed in date order

    I want to create a linked monthly summary table which will show:

    new col A (manually entered): each name once in alphabetical order (employee list)

    in new col B : cumulative total of hours worked by a single matched individual name + macthed at 10% rate (to match conditions looking at rows A & F - if both conditions met then add that hh:mm time in E to a sum

    in new col C : cumulative total of hours worked by a single matched individual name + at 20% rate (to match conditions looking at rows A & F - if both conditions met then add that hh:mm time to a sum total)

    Struggling with the if / then aspect for the sum if selected conditions are met in 2 data range- know this is wrong, tried multiple variations.
    =IF(COUNTIF($A$2:$A$30,"NAME")>0,AND,COUNTIF($F$2:$F$30,"10%")>0)=SUM($E$2:$E$30)

    Any Help or advice ? Thanks

    1. Hi Dominic,

      For me to be able to help you better, please share an editable copy of your spreadsheet with us: support@apps4gs.com. Specify where your formula is and add a second sheet with the result you expect to get. The result sheet is of great importance and often gives us a better understanding than any text description.

      If you have confidential information there, you can replace it with some irrelevant data, just keep the format.

      Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

      I'll look into your task and try to help.

  48. Team, Could you help me with the Google sheet formula to get the counts of Text using logical function.
    Example:
    If(Text=" Company"(Coulumn 1), Countif("Data Base",! 'Active')+countif("Database", 'Inactive')-Different column combined needs to get the result

    1. Hello Gopi,

      Sorry but your task is unclear. Please consider sharing a small sample spreadsheet with us (support@apps4gs.com) with 2 sheets: (1) a copy of your source data (2) the result you expect to get. The result sheet is of great importance and often gives us a better understanding than any text description. I kindly ask you to shorten the tables to 10-20 rows.

      Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm by replying to this comment.

      I'll look into your task and try to help.

  49. DROP BOX = MALAYSIA,SINGAPORE,FILIPINE
    how.

    select malaysia = 17% /
    select singapore = 16%

    please help

  50. Hi, can you help me how to make a formula that based on the covered period time it will call the window:

    1st window
    4-8PM
    2nd window
    8-12MN
    3rd window
    12MN-4AM
    4th window
    4-8AM
    5th window
    08-12NN
    6th window
    12-4PM

    Thanks.

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 :)