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