# Search:

Type: Posts; User: Marcelo Branco; Keyword(s):

Page 1 of 6 1

1. ## Thread: SUMIFS Across Rows with Multiple Criteria

by Marcelo Branco
Replies
1
Views
12

### Re: SUMIFS Across Rows with Multiple Criteria

Welcome to Mr Excel Forum

Dates as mm/dd/yyyy

A
B
C
D
E
2. ## Thread: Formulas to count including Unique Numbers

by Marcelo Branco
Replies
45
Views
2,356

### Re: Formulas to count including Unique Numbers

Graham,

This thread is getting too long...
New data? I suggest you create a new thread - new data sample along with expected results.

M.
3. ## Thread: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

by Marcelo Branco
Replies
11
Views
181

### Re: How to extract only first 2 items, from different groups in the same data, meeting certain criteria

Maybe something like this...

A
B
C
D
E
F
4. ## Thread: Defining an Array Within a Formula

by Marcelo Branco
Replies
3
Views
81

### Re: Defining an Array Within a Formula

You are welcome. Glad to help.

M.
5. ## Thread: Defining an Array Within a Formula

by Marcelo Branco
Replies
3
Views
81

### Re: Defining an Array Within a Formula

To create a vertical array with 5 single results you can try something like

CHOOSE({1;2;3;4;5},result1,result2,result3,result4,result5)

M.
6. ## Thread: If, and, or

by Marcelo Branco
Replies
4
Views
78

### Re: If, and, or

Maybe this array formula...

=AND(B3="V",SUM(IF(MOD(COLUMN(AF3:AX3)-COLUMN(AF3)+1,2)=1,IF(AF3:AX3="B",IF(ABS(Q3-AQ3:BI3)<=2.25,1))))>0)
confirmed with Ctrl+Shift+Enter, not just Enter

M.
7. ## Thread: Sum numbers in cell seperated by a comma

by Marcelo Branco
Replies
8
Views
166

### Re: Sum numbers in cell seperated by a comma

You are welcome. Thanks for the feedback.

M.
8. ## Thread: Sum numbers in cell seperated by a comma

by Marcelo Branco
Replies
8
Views
166

### Re: Sum numbers in cell seperated by a comma

Maybe this...

A
B

1
Text
Sum
9. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
395

### Re: Issue with rank formula

If the cities are grouped and there are no blank rows in the middle, maybe this simpler array formula

A
B
C
D
E
10. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
395

### Re: Issue with rank formula

This scenario - multiple cities with the same value and different ranks - and adding the possibility of blank cells, requires a complex array formula. Would this be convenient for you? Or would it...
11. ## Thread: Skills Matrix equation help

by Marcelo Branco
Replies
2
Views
62

### Re: Skills Matrix equation help

Maybe i'm not understanding what you need but it seems to me you can simply use
=(U8-14)*0.11

M.
12. ## Thread: Formulas to count including Unique Numbers

by Marcelo Branco
Replies
45
Views
2,356

### Re: Formulas to count including Unique Numbers

To use an OR condition in an array formula you should add the conditions, for example
...
13. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
395

### Re: Issue with rank formula

Result #N/A???? Don't understand how a formula using SUMPRODUCT can generate such result :confused:, unless there are errors or blank rows in your data. Check.

Worked perfectly for me...

...
14. ## Thread: Issue with rank formula

by Marcelo Branco
Replies
11
Views
395

### Re: Issue with rank formula

Maybe...

E2 copied down...
15. ## Thread: YTD Sum

by Marcelo Branco
Replies
2
Views
93

### Re: YTD Sum

Maybe

Project 7 Actual YTD
=SUMIFS(INDEX(\$C\$4:\$O\$11,MATCH(B14,B\$4:B\$11,0),0),C\$3:O\$3,"<="&B\$3)
where B14 = Project 7

Project 3 Budget YTD...
16. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
151

### Re: Moving Match formula

You are welcome. Thanks for the feedback.

By the way, a more robust formula (it handles non-existent items)

C9 copied down...
17. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
151

### Re: Moving Match formula

This is a different requirement :confused:
What really do you want? Item A Band 2 or Band 3?

M.
18. ## Thread: Moving Match formula

by Marcelo Branco
Replies
7
Views
151

### Re: Moving Match formula

Maybe something like this...

<tbody>

A
19. ## Thread: MIN & MAX Formula with Multiple Variables

by Marcelo Branco
Replies
10
Views
214

### Re: MIN & MAX Formula with Multiple Variables

Maybe something like this

Sheet1

<tbody>

A
20. ## Thread: MIN & MAX Formula with Multiple Variables

by Marcelo Branco
Replies
10
Views
214

### Re: MIN & MAX Formula with Multiple Variables

Are the dates m/d/yy or d/m/yy?

M.
21. ## Thread: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

by Marcelo Branco
Replies
10
Views
134

### Re: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

Then you should use the solution suggested above by Fluff or VBA. Unfortunately, as far as I know, a formula can't identify a colored cell.

M.
22. ## Thread: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

by Marcelo Branco
Replies
10
Views
134

### Re: Without using VBA, is there a way to count how many GREEN cells there are in a row and display the sum of said green cells in Cell names Total

What is the criterion (logic) that is used to manually color cells green? Greater than a certain value? Does it contain some keyword? Or any other criteria (?)
I believe they are not randomly...
23. ## Thread: MIN & MAX Formula with Multiple Variables

by Marcelo Branco
Replies
10
Views
214

### Re: MIN & MAX Formula with Multiple Variables

Could you provide the expected results and how do you want them displayed in Sheet3?

M.
24. ## Thread: Ranking with SUMPRODUCT to ignore blanks

by Marcelo Branco
Replies
33
Views
9,199

### Re: Ranking with SUMPRODUCT to ignore blanks

You are welcome. Glad to help.

M.
25. ## Thread: Ranking with SUMPRODUCT to ignore blanks

by Marcelo Branco
Replies
33
Views
9,199

### Re: Ranking with SUMPRODUCT to ignore blanks

Something like this

A
B
C
D
E
F
Results 1 to 25 of 150
Page 1 of 6 1