| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a value if 2 Conditions apply
I want to return a value in a database listing if 2 conditions apply. This
value is Text. I have the following formula which works great when I am search for a numeric field but doesn't work when the value is Text =SUMPRODUCT(--(Consol.SalesDate=D$1)*(Consol.Area="EUR"),((Conso l.Comments))) The Consol.Comments range is the value I am trying to return. If I use the above formula it returns 0, not the correct answer |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How many conditions can I apply to a cell? I need to apply 8. | Excel Discussion (Misc queries) | |||
| Summing if several conditions apply | Excel Worksheet Functions | |||
| Apply conditions on Input box continuation! | Excel Programming | |||
| How to apply conditions on Input box? | Excel Programming | |||
| cell = null if conditions apply | Excel Programming | |||
![John[_110_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
