ExcelBanter - Conditional sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional sum (https://www.excelbanter.com/excel-discussion-misc-queries/215348-conditional-sum.html)

Martin G

Conditional sum

I have created a formula using the conditional sum feature. Now I want to
copy the formulas to other cells, but the system returns "0" all the time (as
if the formula does not work properly anymore).

any idea why this happens and how it can be solved?

Thanks a lot.

Regards, Martin

Mike H

Conditional sum

Post your formula

"Martin G" wrote:

I have created a formula using the conditional sum feature. Now I want to
copy the formulas to other cells, but the system returns "0" all the time (as
if the formula does not work properly anymore).

any idea why this happens and how it can be solved?

Thanks a lot.

Regards, Martin

Martin G[_2_]

Conditional sum

=SUM(IF('Data Import'!$B$2:$B$3500="AGH",IF('Data
Import'!$O$2:$O$3500="A",'Data Import'!$J$2:$J$3500,0),0))

"Mike H" wrote:

Post your formula

"Martin G" wrote:

I have created a formula using the conditional sum feature. Now I want to
copy the formulas to other cells, but the system returns "0" all the time (as
if the formula does not work properly anymore).

any idea why this happens and how it can be solved?

Thanks a lot.

Regards, Martin

All times are GMT +1. The time now is 04:49 PM.