Find amount in row.

[art]

Thanks. But now I can't use the Large function. I want to be able to use the
same thing to get one less the MAX or two less than Max etc. Is this possible
with your current formula?

Thanks, your'e the best T. Valko.

 

[Ashish Mathur]

Hi,

you can try this. Suppose the table below is is in range F1:I4. In cell
J2, enter =max(G2:I2) and copy down. in cell J1, type Max

Now in cell A1 and B1, enter Type and Max respectively. In A2 and A3, enter
Plastic and Wood respectively. In cell A4, enter
=DSUM($F$1:$J$4,B1,A1:A3).

Please remember that for the Database functions I.e. DSUM, DCOUNT etc,
blanks are treated as all inclusive and therefore if you delete the entry in
cell A3, the result will be summation of all entries in the Max column.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Ashish Mathur]

Hi,

you can try this. Suppose the table below is is in range F1:I4. In cell
J2, enter =max(G2:I2) and copy down. in cell J1, type Max

Now in cell A1 and B1, enter Type and Max respectively. In A2 and A3, enter
Plastic and Wood respectively. In cell A4, enter
=DSUM($F$1:$J$4,B1,A1:A3).

Please remember that for the Database functions I.e. DSUM, DCOUNT etc,
blanks are treated as all inclusive and therefore if you delete the entry in
cell A3, the result will be summation of all entries in the Max column.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[art]

But I also need to use this for the second to the largest and the third to
largest and so on. So I can't really use MAX. Is there a way that I can can
calculate the whole thing in one cell?


Thanks for your help.

 

[art]

But I also need to use this for the second to the largest and the third to
largest and so on. So I can't really use MAX. Is there a way that I can can
calculate the whole thing in one cell?


Thanks for your help.

 

[T. Valko]

Is this possible with your current formula?

No.

I don't know how to do what you want in a single formula.

 

[T. Valko]

Is this possible with your current formula?

No.

I don't know how to do what you want in a single formula.