View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
userofexcel userofexcel is offline
external usenet poster
 
Posts: 1
Default How do I use LOOKUP to return a range of values, then SUM values?


Two questions:
1- why not sum in the talley cell with a simple function?
2- are you talleying the month or the year?

it is not clear in your decription, each month then you total the year?


--
userofexcel
------------------------------------------------------------------------
userofexcel's Profile: http://www.excelforum.com/member.php...o&userid=37040
View this thread: http://www.excelforum.com/showthread...hreadid=568176