conditional sum if

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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 Graesse
(e-mail address removed)
Boston M

----- (e-mail address removed) 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
 
you mean i didn't have to learn the SUMPRODUCT function !!!!!!!!!!

Mark Graesser said:
Hi Julie.
It's an Add-in (at least in excel 97). Once you add it in , a new item
Click to expand...
named "Wizard" will be at the bottom of your Tools menu.
 
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)
 
Now if I could only figure out these darn Array functions

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

ah, but think how much your life has been enriched

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct
 
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
 
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?
Click to expand...
Also include the formula that the wizard created.
What do you mean by "create a brand new spreadsheet with
Click to expand...
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"?
 
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)




.
Click to expand...
 
Back
Top