conditional sum - additional info

  • Thread starter Thread starter Tat
  • Start date Start date
T

Tat

How can you copy conditional sum to other cells. I always
get a value error. So far I have to input this add-in cell
by cell. Not very efficient.
I tried copying and just changing the range in the formula
but it still gives me a value error.

example: =SUM(IF($C$8:$C$185="DTO-A-H",$D$8:$D$185,0))

I cant change the range, nor can I change the criteria
without the value error.
 
Tat

You have set it up with totally absolute references. These will not change
when you copy and paste elsewhere. If you copy and paste and change the
ranges, you must make sure they still cover the same number of cells.

Andy.
 
Tat said:
How can you copy conditional sum to other cells. I always
get a value error. So far I have to input this add-in cell
by cell. Not very efficient.
I tried copying and just changing the range in the formula
but it still gives me a value error.

example: =SUM(IF($C$8:$C$185="DTO-A-H",$D$8:$D$185,0))

I cant change the range, nor can I change the criteria
without the value error.
Click to expand...

Please don't start another thread for exactly the same query. See the answer
to your original post.
 
I'm using the add-in under tools menu. It comes up with a
wizard. So all that is necessary is to fill in the
information it requests. The wizard figures out the
formula. For example the information I am providing is 2
colum ranges...one that has a list of names (some of which
are repeated) the other has a list of values (these ranges
are to remain constant for all calculations that's why
there ranges have the $ symbol). If the list of names are
the same then all the corresponding values are added.
I even tried manually entering the formula in a cell but
that also does not work. I notice when I do check the
formula that the wizard created it has { at the beginning
of the formula and } at the end. I tried adding that as
well but that doesn't work either.
 
Back
Top