Finding Max of Column that Varies

[QBtrades]

I want to find the Max of a column if other columns have 1's in it but the 1's vary.

Here is an example: I want to find the Max of column A after the first 1 in column B shows until the next 1 in column C shows above.

So in this example the first 1 in Column B shows at A7. So the Max from A6:A1 (next 1 above in Column C is at C1) is 15. There is a 1 in A10 with the first 1 in column C above it at C9. So the Max of A9 issue 10...and so forth

A---------B---------C---------D
10--------0---------1---------15
12--------0---------0---------""
14--------0---------0---------""
12--------1---------0---------""
10--------1---------0---------""
15--------1---------0---------""
20--------1---------0---------""
25--------0---------0---------""
10--------0---------1---------10
12--------1---------0---------""
14--------0---------0---------""
12--------0---------0---------""
10--------0---------1---------15
15--------1---------0---------""
20--------1---------0---------""
25--------0---------0---------""

The "" are just blank cells

Hope this makes sense.

 

[Aladin Akyurek]

Yes I do. I know how to enter an array. I'm not that much of a rookie to excel. I did everything you said. Formula doesn't work for me. Thanks

In A17 enter and copy across to C17:

=SUM(A1:A16)

Care to post the results you obtain?