Thread: Sumif Function
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ml0
 
Posts: n/a
Default Sumif Function


Eureka, I got it to work!!! My problem was that the headers were
included in the referenced cells. When I redefined the range to
eliminate the headers it works. So instead of E1:E29000, I changed it
to E2:E29000. It had to be user error.

Thanks for your help, I have been trying to figure this problem out for
quite a while.


--
ml0
------------------------------------------------------------------------
ml0's Profile: http://www.excelforum.com/member.php...o&userid=31121
View this thread: http://www.excelforum.com/showthread...hreadid=507874