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

Thats great, I'm glad you have a resolution,
Regards,
Alan.
"ml0" wrote in message
...

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