Do you really mean to count the items, or sum the amounts (albeit they are
in text form)?
Can you give us some sample data.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"tjkyon" wrote in message
...
Hi, I'm trying to get excel to count the last 12 months of data in a
particular row for multiple years. The data in the rows are not numeric
values, but text values. Basically, on a monthly basis, I want the sheet
to
get rid of the oldest month and include the newest month (currently, i
want
the sheet to drop jan '04 and add jan '05).....
any thoughts?
thanks
|