| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT AND LEFT
I'm trying to get this formula to work but it's giving a #NA value. The
formula works fine until I add the last condition with the LEFT function. =SUMPRODUCT(('CPO Tracking Log'!Q14:Q41=DATE(2008,6,1))*('CPO Tracking Log'!Q14:Q41<=DATE(2008,6,30))*(LEFT('CPO Tracking Log'!$C$14:$C$66,2)="RA")) What I would ideally like to do is to use a wildcard function for the last condition, so that if the cell contains RA in the begining or end then sum it. HELP? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make left side stay still and right side can move left to r | Excel Discussion (Misc queries) | |||
| My Excel view is Right to Left instead of Left to Right !!! | Excel Discussion (Misc queries) | |||
| Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
| Left and Sumproduct | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
Threaded Mode
