| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"OR" Function in an Array Formula
Hi,
Can someone tell me what is wrong with my formula? It seems that the "OR" function in this formula is not working. It is bringing back a zero when there should be a number. {=SUM(IF((GrossMargin!$B$29:$B$89=Metrics!$B35)*($ C35=GrossMargin!$C $29:$C$89)+($D35=GrossMargin!$C$29:$C$89),GrossMar gin!BF$29:BF$89,0))} Thanks, Sherry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
| Cannot Reference "Array" in Subtotal Function | Excel Worksheet Functions | |||
Threaded Mode
