| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wanting to add best 3 out of 4 numbers in Excel?
Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same
etc. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
GE,
=SUM(A1:A4) - MIN(A1:A4) or =SUM(A1:A4) - MAX(A1:A4) depending on what "Best" means (highest or lowest). And we generally can't read your mind to know exactly what "etc." means..... HTH, Bernie MS Excel MVP "GE" wrote in message ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
Hi
try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
Frank,
Not sure what character set you're using ;-) =SUM(LARGE(A1:A100,{1,2,3})) HTH, Bernie MS Excel MVP "Frank Kabel" wrote in message ... Hi try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
Hi Bernie
vcery strange. I'm sure i hit the {} keys??? Thanks for the correction -- Regards Frank Kabel Frankfurt, Germany "Bernie Deitrick" <deitbe @ consumer dot org schrieb im Newsbeitrag ... Frank, Not sure what character set you're using ;-) =SUM(LARGE(A1:A100,{1,2,3})) HTH, Bernie MS Excel MVP "Frank Kabel" wrote in message ... Hi try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
I think something got lost in Franks' post when it hit the NG I am sure it
should be =SUM(LARGE(A1:A100,{1,2,3})) -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
Hi Bob
thick fingers on my side - I guess :-)) -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... I think something got lost in Franks' post when it hit the NG I am sure it should be =SUM(LARGE(A1:A100,{1,2,3})) -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
Doubt it, not close enough. It looks like something happened en-route.
Bob "Frank Kabel" wrote in message ... Hi Bob thick fingers on my side - I guess :-)) -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... I think something got lost in Franks' post when it hit the NG I am sure it should be =SUM(LARGE(A1:A100,{1,2,3})) -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Wanting to add best 3 out of 4 numbers in Excel?
Hi
on my keyboard layout it is <vbg instead of hitting ALTGR I hit the "<" -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... Doubt it, not close enough. It looks like something happened en-route. Bob "Frank Kabel" wrote in message ... Hi Bob thick fingers on my side - I guess :-)) -- Regards Frank Kabel Frankfurt, Germany "Bob Phillips" schrieb im Newsbeitrag ... I think something got lost in Franks' post when it hit the NG I am sure it should be =SUM(LARGE(A1:A100,{1,2,3})) -- HTH RP (remove nothere from the email address if mailing direct) "Frank Kabel" wrote in message ... Hi try =SUM(LARGE(A1:A100,<71,2,3<0)) -- Regards Frank Kabel Frankfurt, Germany "GE" schrieb im Newsbeitrag ... Looking to add best 3 of 4 numbers in Excell, if all 4 numbers are the same etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not wanting #div/0 to chart as zero | Charts and Charting in Excel | |||
| Not wanting to plot #div/0 | Charts and Charting in Excel | |||
| Wanting to automate: Change name of several excel documents | Excel Discussion (Misc queries) | |||
| Wanting to sum a colum of numbers and then roundup to the next dol | Excel Worksheet Functions | |||
| Wanting to know if this is possible | Excel Discussion (Misc queries) | |||
Linear Mode
