Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula help
I have a cell with this formula:
{=INDEX(B:B,MAX((B1:B368<0)*ROW(INDIRECT("1:368") )))/(316+COUNTIF(D3:D368," 0"))} I don't remember how it was made up (I got help on this forum), but now I need to update it by changing the 316 summed value in the last expression to 681. When I do that, the starting and ending braces disappear, and the cell containing this formula returns a #VALUE! message. How to fix? Thanks. -- Bill |
#2
|
|||
|
|||
Hi
enter this formula with CTRL+SHIFT+ENTER (to create an array formula) -- Regards Frank Kabel Frankfurt, Germany "Bill H." schrieb im Newsbeitrag ... I have a cell with this formula: {=INDEX(B:B,MAX((B1:B368<0)*ROW(INDIRECT("1:368") )))/(316+COUNTIF(D3:D368," 0"))} I don't remember how it was made up (I got help on this forum), but now I need to update it by changing the 316 summed value in the last expression to 681. When I do that, the starting and ending braces disappear, and the cell containing this formula returns a #VALUE! message. How to fix? Thanks. -- Bill |
#3
|
|||
|
|||
Say, that works GREAT!
Thanks. "Frank Kabel" wrote in message ... Hi enter this formula with CTRL+SHIFT+ENTER (to create an array formula) -- Regards Frank Kabel Frankfurt, Germany "Bill H." schrieb im Newsbeitrag ... I have a cell with this formula: {=INDEX(B:B,MAX((B1:B368<0)*ROW(INDIRECT("1:368") )))/(316+COUNTIF(D3:D368," 0"))} I don't remember how it was made up (I got help on this forum), but now I need to update it by changing the 316 summed value in the last expression to 681. When I do that, the starting and ending braces disappear, and the cell containing this formula returns a #VALUE! message. How to fix? Thanks. -- Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Data Label Value in Formula? | Charts and Charting in Excel | |||
create a chart with a formula | Charts and Charting in Excel | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel |