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

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

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

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

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

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