| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compound Functions
=IF(AND($F$8:$F$100="",$E$8:$E$100="PCO"), SUM($G$8:$G$100), 0)
Returns 0 when it should a sum of numbers. My Logic is: When column f is blank and column E = "PCO" then sum column G. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
| Are financial functions calculated based on compound interest? | Excel Worksheet Functions | |||
Threaded Mode
