Calculations Help!
 

Hi,

I am trying to calculate totals in a spread sheet depending on two cell
values. i.e. if cell1 = 610 and cell2 = 110 then calculate the value cells.

Here's a better example:

Value Dep Expen
179 610 110
-620 610 110
-718.98 610 110
-159.99 610 110
-870.5 610 110
65.54 610 115
15.54 610 115

From this I want the totals for Dep=610 and Expen=110 (adding all of the
relevant 'value' cells for these values - total should be -2190.47) and the
totals for Dep=610 and Expen=115 (total should be 81.08) etc.

Is there any way I can do this?

Any help would be appreciated as this is driving me mad.

Thanks in advance.

J

Hi
=SUMPRODUCT(--(B1:100=610),--(C1:C100=110),A1:A100)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

JenC wrote:
Hi,

I am trying to calculate totals in a spread sheet depending on two
cell values. i.e. if cell1 = 610 and cell2 = 110 then calculate the
value cells.

Here's a better example:

Value Dep Expen
179 610 110
-620 610 110
-718.98 610 110
-159.99 610 110
-870.5 610 110
65.54 610 115
15.54 610 115

From this I want the totals for Dep=610 and Expen=110 (adding all of
the relevant 'value' cells for these values - total should be
-2190.47) and the totals for Dep=610 and Expen=115 (total should be
81.08) etc.

Is there any way I can do this?

Any help would be appreciated as this is driving me mad.

Thanks in advance.

J