| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
a stuborne formula - that just won't work
The following formula works great:
=SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am compliance"),--('Filled Reqs'!$I$2:$I$389="NC")) It displays points on a graph like it should for 24 out of the 26 depts. After I copied from 1 cell all the way down and changed the dept names I pressed CTRL+SHIFT+ENTER for each, { } displays in the array. It displays 0 in 2 of the cells. I tried re-copy, delete the cell and retype the formula nothing seems to work. In order to present the chart I've manually had to calculate what should be in the cell and entered it, which replaces the formula that was there . Any thoughts of why this doesn't work all the time ??????? Ralph |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
a stuborne formula - that just won't work
SUMPRODUCT is not an array function; enter it normally
Does this help? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ralph D''Andrea" wrote in message ... The following formula works great: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am compliance"),--('Filled Reqs'!$I$2:$I$389="NC")) It displays points on a graph like it should for 24 out of the 26 depts. After I copied from 1 cell all the way down and changed the dept names I pressed CTRL+SHIFT+ENTER for each, { } displays in the array. It displays 0 in 2 of the cells. I tried re-copy, delete the cell and retype the formula nothing seems to work. In order to present the chart I've manually had to calculate what should be in the cell and entered it, which replaces the formula that was there . Any thoughts of why this doesn't work all the time ??????? Ralph |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
a stuborne formula - that just won't work
Hi Bernard,
I'd like to send you the spreadsheet, seeing is believing. there's nowhere to attach a document. Send me your email address and I'll forward it on Thanks "Bernard Liengme" wrote: SUMPRODUCT is not an array function; enter it normally Does this help? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ralph D''Andrea" wrote in message ... The following formula works great: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am compliance"),--('Filled Reqs'!$I$2:$I$389="NC")) It displays points on a graph like it should for 24 out of the 26 depts. After I copied from 1 cell all the way down and changed the dept names I pressed CTRL+SHIFT+ENTER for each, { } displays in the array. It displays 0 in 2 of the cells. I tried re-copy, delete the cell and retype the formula nothing seems to work. In order to present the chart I've manually had to calculate what should be in the cell and entered it, which replaces the formula that was there . Any thoughts of why this doesn't work all the time ??????? Ralph |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
a stuborne formula - that just won't work
My email is in my messages but remove the word in caps
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Bernard Liengme" wrote in message ... SUMPRODUCT is not an array function; enter it normally Does this help? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ralph D''Andrea" wrote in message ... The following formula works great: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am compliance"),--('Filled Reqs'!$I$2:$I$389="NC")) It displays points on a graph like it should for 24 out of the 26 depts. After I copied from 1 cell all the way down and changed the dept names I pressed CTRL+SHIFT+ENTER for each, { } displays in the array. It displays 0 in 2 of the cells. I tried re-copy, delete the cell and retype the formula nothing seems to work. In order to present the chart I've manually had to calculate what should be in the cell and entered it, which replaces the formula that was there . Any thoughts of why this doesn't work all the time ??????? Ralph |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
a stuborne formula - that just won't work
It is in my message just remove the word in caps
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ralph D''Andrea" wrote in message ... Hi Bernard, I'd like to send you the spreadsheet, seeing is believing. there's nowhere to attach a document. Send me your email address and I'll forward it on Thanks "Bernard Liengme" wrote: SUMPRODUCT is not an array function; enter it normally Does this help? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ralph D''Andrea" wrote in message ... The following formula works great: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am compliance"),--('Filled Reqs'!$I$2:$I$389="NC")) It displays points on a graph like it should for 24 out of the 26 depts. After I copied from 1 cell all the way down and changed the dept names I pressed CTRL+SHIFT+ENTER for each, { } displays in the array. It displays 0 in 2 of the cells. I tried re-copy, delete the cell and retype the formula nothing seems to work. In order to present the chart I've manually had to calculate what should be in the cell and entered it, which replaces the formula that was there . Any thoughts of why this doesn't work all the time ??????? Ralph |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
a stuborne formula - that just won't work
I sent it along under seperate cover
"Bernard Liengme" wrote: My email is in my messages but remove the word in caps -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Bernard Liengme" wrote in message ... SUMPRODUCT is not an array function; enter it normally Does this help? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Ralph D''Andrea" wrote in message ... The following formula works great: =SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389=("08/01/07"+0)),--('Filled Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am compliance"),--('Filled Reqs'!$I$2:$I$389="NC")) It displays points on a graph like it should for 24 out of the 26 depts. After I copied from 1 cell all the way down and changed the dept names I pressed CTRL+SHIFT+ENTER for each, { } displays in the array. It displays 0 in 2 of the cells. I tried re-copy, delete the cell and retype the formula nothing seems to work. In order to present the chart I've manually had to calculate what should be in the cell and entered it, which replaces the formula that was there . Any thoughts of why this doesn't work all the time ??????? Ralph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cant quite get this formula to work: | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| How do I get this formula to work? | Excel Discussion (Misc queries) | |||
| How does this formula work | Excel Worksheet Functions | |||
| formula won't work | Excel Worksheet Functions | |||
Linear Mode
