View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mashuganah Mashuganah is offline
external usenet poster
 
Posts: 27
Default Compare an Array to a Date Range

Biff,

I've broken your equation in half and each half appears to work
independently, i.e., the MONTH equation and the ISNUMBER equation. However,
when they're put together under SUMPRODUCT I get the #Value error.

Greg