conditional sum if

I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the wizard - I can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.

Any thoughts?

When I create a brand new spreadsheet with the same data -
it works fine.

Do you remember to commit with Ctrl-Shift-Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the wizard - I can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.

Any thoughts?

When I create a brand new spreadsheet with the same data -
it works fine.

could someone please enlighten me to where this feature is?

Cheers
JulieD

"Bob Phillips" wrote in message
...
Do you remember to commit with Ctrl-Shift-Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the wizard - I can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.

Any thoughts?

When I create a brand new spreadsheet with the same data -
it works fine.

you mean i didn't have to learn the SUMPRODUCT function !!!!!!!!!!

"Mark Graesser" wrote in message
...
Hi Julie.
It's an Add-in (at least in excel 97). Once you add it in , a new item
named "Wizard" will be at the bottom of your Tools menu.

Regards,
Mark Graesser


----- JulieD wrote: -----

could someone please enlighten me to where this feature is?

Cheers
JulieD

"Bob Phillips" wrote in message
...
Do you remember to commit with Ctrl-Shift-Enter.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
wrote in message
...
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the wizard - I can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.
Any thoughts?
When I create a brand new spreadsheet with the same data -
it works fine.

Now if I could only figure out these darn Array functions.

----- Bob Phillips wrote: -----

ah, but think how much your life has been enriched!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JulieD" wrote in message
...
you mean i didn't have to learn the SUMPRODUCT function !!!!!!!!!!
"Mark Graesser" wrote in message
...
Hi Julie.
It's an Add-in (at least in excel 97). Once you add it in , a new item
named "Wizard" will be at the bottom of your Tools menu.
Regards,
Mark Graesser
----- JulieD wrote: -----
could someone please enlighten me to where this feature is?
Cheers
JulieD
"Bob Phillips" wrote in message
...
Do you remember to commit with Ctrl-Shift-Enter.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
wrote in message
...
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the wizard - I can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.
Any thoughts?
When I create a brand new spreadsheet with the same data -
it works fine.

I'm with you on that one Mark ... my current theory is whenever there's a
question that i don't know the answer for, make up something and press
Shift+Control+Enter and see if it works

JulieD

"Mark Graesser" wrote in message
...
Now if I could only figure out these darn Array functions.

----- Bob Phillips wrote: -----

ah, but think how much your life has been enriched!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JulieD" wrote in message
...
you mean i didn't have to learn the SUMPRODUCT function !!!!!!!!!!
"Mark Graesser" wrote in
message
...
Hi Julie.
It's an Add-in (at least in excel 97). Once you add it in , a new
item
named "Wizard" will be at the bottom of your Tools menu.
Regards,
Mark Graesser
----- JulieD wrote: -----
could someone please enlighten me to where this feature is?
Cheers
JulieD
"Bob Phillips" wrote in
message
...
Do you remember to commit with Ctrl-Shift-Enter.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
wrote in message
...
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the wizard - I can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.
Any thoughts?
When I create a brand new spreadsheet with the same data -
it works fine.

I have several columns with rows of information
Job number/"I" designation if it is an internet job/"T"
designation if it is international work/study price

Not all jobs are "I" and not all jobs are "T". So the
formula I am trying to create is to sum the study price
column if it contains an "I" and a "T" so that we can
evaluate how much international internet work we are doing.

We have already been using a spreadsheet to keep track of
all the jobs. This "I" "T" evaluation is something new
they want to check out. So the spreadsheet has been
around a while & when I try to do a conditional sum - it
doesn't seem to work. I go through the wizard and the
very last screen shows the total study price that meets
the criteria, however - when I finish the wizard & it puts
it in the designated destination cell - the result is
incorrect.

If I start with a blank workbook and key in the same
values, then do the conditional sum wizard, I get the
correct result in the destination cell. The only thing I
can figure is that it has something to do with the
formating in the original workbook (I have custom
formatting).

Any thoughts?
-----Original Message-----
Hello,
Could you describe an example you have had trouble with?
Also include the formula that the wizard created.

What do you mean by "create a brand new spreadsheet with
the same data "? If this is a brand new spread sheet,
then the function from the wizard wouldn't be on it, so
how could "work fine"?

Regards,
Mark Graesser

Boston MA

----- wrote: -----

I just recently started using the conditional sum if
feature (array). I go through the entire wizard
using an
existing spreadsheet. The last step of the wizard -
I can
see the result of the calculation, but when it puts
it
into the cell I selected, the result is incorrect.

Any thoughts?

When I create a brand new spreadsheet with the same
data -
it works fine.

.

Yes - I remembered that
-----Original Message-----
Do you remember to commit with Ctrl-Shift-Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using
an
existing spreadsheet. The last step of the wizard - I
can
see the result of the calculation, but when it puts it
into the cell I selected, the result is incorrect.

Any thoughts?

When I create a brand new spreadsheet with the same
data -
it works fine.


.

Here is the formula {=SUM(IF($B$8:$B$205="I",IF
($D$8:$D$205="T",$G$8:$G$205,0),0))}
-----Original Message-----
I have several columns with rows of information
Job number/"I" designation if it is an internet job/"T"
designation if it is international work/study price

Not all jobs are "I" and not all jobs are "T". So the
formula I am trying to create is to sum the study price
column if it contains an "I" and a "T" so that we can
evaluate how much international internet work we are
doing.

We have already been using a spreadsheet to keep track of
all the jobs. This "I" "T" evaluation is something new
they want to check out. So the spreadsheet has been
around a while & when I try to do a conditional sum - it
doesn't seem to work. I go through the wizard and the
very last screen shows the total study price that meets
the criteria, however - when I finish the wizard & it
puts
it in the designated destination cell - the result is
incorrect.

If I start with a blank workbook and key in the same
values, then do the conditional sum wizard, I get the
correct result in the destination cell. The only thing I
can figure is that it has something to do with the
formating in the original workbook (I have custom
formatting).

Any thoughts?
-----Original Message-----
Hello,
Could you describe an example you have had trouble
with?
Also include the formula that the wizard created.

What do you mean by "create a brand new spreadsheet with
the same data "? If this is a brand new spread sheet,
then the function from the wizard wouldn't be on it, so
how could "work fine"?

Regards,
Mark Graesser

Boston MA

----- wrote: -----

I just recently started using the conditional sum
if
feature (array). I go through the entire wizard
using an
existing spreadsheet. The last step of the wizard -

I can
see the result of the calculation, but when it puts
it
into the cell I selected, the result is incorrect.

Any thoughts?

When I create a brand new spreadsheet with the same
data -
it works fine.

.

.