| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
