# Search:

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

Page 1 of 6 1

## Search: Search took 1.90 seconds.

Replies
27
Views
654

### Re: AverageIfs Complexity

You need to apply control+shift+enter at the same time.

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. ## Thread: Help unstanding this formula?

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. ## Thread: sumif or sumproduct based on current month and year

Replies
7
Views
224

### 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. ## Thread: How to always Reference Cell even if deleted?

Replies
12
Views
3,368

### Re: How to always Reference Cell even if deleted?

Try:

=IF(ISNUMBER(INDIRECT("C14")),EOMONTH(INDIRECT("C14"),0),"no date")
6. ## Thread: Vlookup on multiple matches

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. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
19
Views
41,406

### 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. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
19
Views
41,406

### Re: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

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

Replies
7
Views
224

### 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. ## Thread: Array Formula to Remove Zero Value Rows

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. ## Thread: Using the =IF(ISNUMBER(SEARCH function to search multiple cells...

Replies
19
Views
41,406

### 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. ## Thread: Formula to Create a List from and Existing List ignoring zero values

Replies
9
Views
5,445

### Re: Formula to Create a List from and Existing List ignoring zero values

You are welcome.

Replies
5
Views
310

### 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. ## Thread: Formula to Create a List from and Existing List ignoring zero values

Replies
9
Views
5,445

### 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. ## Thread: sumifs with date and text criteria

Replies
9
Views
326

### Re: sumifs with date and text criteria

You are welcome.
16. ## Thread: sumifs with date and text criteria

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. ## Thread: sumifs with date and text criteria

Replies
9
Views
326

### Re: sumifs with date and text criteria

Is this count what you would expect to obtain?
18. ## Thread: sumifs with date and text criteria

Replies
9
Views
326

### Re: sumifs with date and text criteria

Sorry, I meant just:

=
COUNTIF(G5:G33,"TextSave")
19. ## Thread: sumifs with date and text criteria

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. ## Thread: Countifs based on another tables components

Replies
5
Views
986

### Re: Countifs based on another tables components

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

Replies
11
Views
458

### 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. ## Thread: Countifs based on another tables components

Replies
5
Views
986

### 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. ## Thread: Countifs based on another tables components

Replies
5
Views
986

### Re: Countifs based on another tables components

What are "some conditions" and what is the expected "count"?
24. ## Thread: SUMIFS formula help

Replies
4
Views
265

### Re: SUMIFS formula help

Great. You are welcome.