Re: sum up the ROW values with ref to COLUMN values!




yes..mr ron!
the problem was in the month names. as u said when i changed the name
of the months from excel format to text..ur formula clicks well!! thks
very much for your prompt clarification..! just for acadamic interest i
am asking the question..why it is not working when the cells are filled
up with months using autofill series?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26725
View this thread: http://www.excelforum.com/showthread.php?threadid=496051

.



Relevant Pages

  • Re: Need Sorting Help
    ... Ron, ... still learning ... still learning's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23900 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: minimum a fixed figure when it is lower
    ... thanks benjie and ron for the reply. ... weepel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24531 ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Add to zip file and email
    ... Thanks again Ron, ... krabople's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29774 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Can VBA determine if a cell/range is in a group?
    ... Ron has pointed me in the right direction. ... BlindGuardian ... BlindGuardian's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24202 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Extracting text from a cell entry
    ... Thanks Ron, that worked perfectly! ... morchard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24761 ... Prev by Date: ...
    (microsoft.public.excel.misc)