# Search:

Type: Posts; User: MARZIOTULLIO; Keyword(s):

Page 1 of 6 1

1. ## Thread: SUMPRODUCT and EXACT problem

by MARZIOTULLIO
Replies
4
Views
192

### Re: SUMPRODUCT and EXACT problem

Can you provide some sample data and what the expected outcome is?
2. ## Thread: Count if Value meets or exceeds criteria

by MARZIOTULLIO
Replies
14
Views
290

<tbody>

a

b

c
3. ## Thread: count cells that string contains X but does not contains Y or Z

by MARZIOTULLIO
Replies
7
Views
229

<tbody>

A

B

C
4. ## Thread: SUMPRODUCT with multiple criteria in Rows and Columns (Still function as SUMPRODUCT instead of SUM or COUNT)

by MARZIOTULLIO
Replies
4
Views
159

<tbody>

A

B

C
5. ## Thread: WeekNumber From Time Sheet Value

by MARZIOTULLIO
Replies
7
Views
122

<tbody>

A

B
6. ## Thread: Search product price by latest date

by MARZIOTULLIO
Replies
7
Views
131

### Re: Search product price by latest date

SALES REGISRATION

D3=IF(\$A3<>"",IF('SALES REGISTRATION'!\$A3=MAX(IF('STOCK '!\$B\$3:\$B\$11='SALES REGISTRATION'!\$B3,IF('STOCK '!\$C\$3:\$C\$11='SALES REGISTRATION'!\$C3,'STOCK...
7. ## Thread: Index Matching with Multiple Criteria and Greater Than

by MARZIOTULLIO
Replies
4
Views
215

<tbody>

A

B

C
8. ## Thread: Countifs ignoring duplicate dates in specific range

by MARZIOTULLIO
Replies
10
Views
419

<tbody>

A

B

C
9. ## Thread: Matrix formula to count months

by MARZIOTULLIO
Replies
7
Views
156

### Re: Matrix formula to count months

You are welcome

Grazie per la risposta
10. ## Thread: Matrix formula to count months

by MARZIOTULLIO
Replies
7
Views
156

<tbody>

A

B

C
11. ## Thread: How many names have a duplicate in a date range

by MARZIOTULLIO
Replies
9
Views
258

<tbody>

A

B

C
12. ## Thread: SUMIFS less than date AND amount is more than zero

by MARZIOTULLIO
Replies
5
Views
235

### Re: SUMIFS less than date AND amount is more than zero

Can you provide some sample data and what the expected outcome is?

maybe

=SUMIFS(C3:C136,C3:C136,">0",A3:A163,"<=30/06/2006")
13. ## Thread: problem formula Index not work after point to relation many column

by MARZIOTULLIO
Replies
5
Views
133

### Re: problem formula Index not work after point to relation many column

You are welcome.
14. ## Thread: problem formula Index not work after point to relation many column

by MARZIOTULLIO
Replies
5
Views
133

### Re: problem formula Index not work after point to relation many column

Hi

B6=SUMPRODUCT((\$D\$3:\$D\$12=B3)*(E3:E12=B4)*(F2:I2=B5)*(F3:I12))
15. ## Thread: problem formula Index not work after point to relation many column

by MARZIOTULLIO
Replies
5
Views
133

### Re: problem formula Index not work after point to relation many column

Can you provide a real file not image and what the expected outcome is ?
16. ## Thread: Count Unique Values That Meet Criteria

by MARZIOTULLIO
Replies
2
Views
147

<tbody>

A

B

C
17. ## Thread: sumifs with 2 sum ranges

by MARZIOTULLIO
Replies
2
Views
214

<tbody>

A

B

C
18. ## Thread: Lookup a number, return a name

by MARZIOTULLIO
Replies
12
Views
236

<tbody>

B

C

D
19. ## Thread: Lookup a number, return a name

by MARZIOTULLIO
Replies
12
Views
236

<tbody>

B

C

D
20. ## Thread: Lookup a number, return a name

by MARZIOTULLIO
Replies
12
Views
236

### Re: Lookup a number, return a name

Hi

Can you provide some sample data and what the expected outcome is?
21. ## Thread: Challenge: Sum cells in one column when adjacent cells are not blank

by MARZIOTULLIO
Replies
3
Views
132

<tbody>

A

B

C
22. ## Thread: Lookup and create a list

by MARZIOTULLIO
Replies
6
Views
312

### Re: Lookup and create a list

Hi

E3=IF(E\$2<>"",IFERROR(INDEX(\$B\$2:\$B\$100,SMALL(IF(\$A\$2:\$A\$100=E\$2,ROW(\$B\$2:\$B\$100)-ROW(\$B\$2)+1),ROWS(\$B\$2:\$B2))),""),"") control+shift+enter copy across and down
23. ## Thread: SUMIFs - simple example

by MARZIOTULLIO
Replies
10
Views
693

Another way

<tbody>

A

B
24. ## Thread: SUMIFs - simple example

by MARZIOTULLIO
Replies
10
Views
693

<tbody>

A

B

C
25. ## Thread: Referencing Value in "Column Groups" (INDEX MATCH..?)

by MARZIOTULLIO
Replies
5
Views
149

### Re: Referencing Value in "Column Groups" (INDEX MATCH..?)

<tbody>

A

B

C
Results 1 to 25 of 150
Page 1 of 6 1