66 41

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"K" wrote in message
...
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?