Search:

Type: Posts; User: Aladin Akyurek; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 1.90 seconds.

  1. Replies
    27
    Views
    654

    Re: AverageIfs Complexity

    You need to apply control+shift+enter at the same time.
  2. Replies
    27
    Views
    654

    Re: AverageIfs Complexity

    Control+shift+enter, not just enter:


    =AVERAGE(IF(LEFT($B$2:$B$150,1)+0=3,$G$2:$G$150))
  3. Replies
    1
    Views
    129

    Re: Help unstanding this formula?

    Try to test with a smaller data area, say, A1:D5, on Sheet1. Enter some data in A1:D5 and also some small numbers in F. Enter the adjusted formula in G1 as:
    ...
  4. Re: sumif or sumproduct based on current month and year

    1. Control+shift+enter is an Excel requirement for signaling Excel that the formula in question is an array-processing formula. Excel's calculation treats such formulas differently (qua algorithms it...
  5. Re: How to always Reference Cell even if deleted?

    Try:

    =IF(ISNUMBER(INDIRECT("C14")),EOMONTH(INDIRECT("C14"),0),"no date")
  6. Replies
    2
    Views
    128

    Re: Vlookup on multiple matches

    The desired output does not seem to show any structure. If thi observation is correct, any random output should be acceptable for a given look up value!
  7. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    Please try to continue this one in https://www.mrexcel.com/forum/excel-questions/893600-extract-multiple-keywords-text-string-3.html. Thank you.
  8. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    You are welcome.
  9. Re: sumif or sumproduct based on current month and year

    Control+shift+enter, not just enter:

    =
    SUM(IF(ISNUMBER(V:$V),IF((MONTH(V:$V)=8)*(YEAR(V:$V)=2019),AI:$AI)))
  10. Replies
    14
    Views
    15,819

    Re: Array Formula to Remove Zero Value Rows

    Try to provide a small input sample along with the output which must obtain from that sample.
  11. Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  12. Re: Formula to Create a List from and Existing List ignoring zero values

    You are welcome.
  13. Re: Return Multiple Column headings in a single Cell

    Excel 2013 does not have the TEXTJPOIN function, hence the #NAME ? error. Try the following instead...

    Add the following VBA code to your workbook as a module, using Alt+F11...

    Function...
  14. Re: Formula to Create a List from and Existing List ignoring zero values

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  15. Replies
    9
    Views
    326

    Re: sumifs with date and text criteria

    You are welcome.
  16. Replies
    9
    Views
    326

    Re: sumifs with date and text criteria

    If G14 = TaxSave, C14 = 30-07-2015, D14 = 54718, AND

    =G14 = "TaxSave" yields TRUE

    =ISNUMBER(C14) yields TRUE

    =(C14 >= "30-07-2018"+0) * (C14 <= "30-07-2018"+0) yields 1

    =ISNUMBER(D14)...
  17. Replies
    9
    Views
    326

    Re: sumifs with date and text criteria

    Is this count what you would expect to obtain?
  18. Replies
    9
    Views
    326

    Re: sumifs with date and text criteria

    Sorry, I meant just:

    =
    COUNTIF(G5:G33,"TextSave")
  19. Replies
    9
    Views
    326

    Re: sumifs with date and text criteria

    The formula looks correct.

    What do you get with:

    =COUNT(D5:D33)

    =COUNT(E5:E33)

    =COUNT(E5:E33)
  20. Re: Countifs based on another tables components

    You are welcome.
  21. Re: Sum the total of duplicated items in a list

    @ richiebkerry

    Control+shift+enter, not just enter:

    =SUM(IF(FREQUENCY(IF(postcodes<>"",IF(weeknums=wnum,MATCH(postscodes,postcodes,0))),ROW(INDEX(postcodes)-ROW(INDEX(postcodes,1,1))+1),1))
    ...
  22. Re: Countifs based on another tables components

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px"...
  23. Re: Countifs based on another tables components

    What are "some conditions" and what is the expected "count"?
  24. Replies
    4
    Views
    265

    Re: SUMIFS formula help

    Great. You are welcome.
  25. Re: Formula should work, but isnt. Text / Values / Hour challenge.

    =(INT($D3*24)-HOUR($C1))&""

    should return a text result.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4