Try using the SubTotals feature on the Data menu.
Your data will have to be sorted so that identical months are in adjacent rows.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"TimmyD"
wrote in message
I have a very large database of monthly meter readings. Some months have
multiple readings, which throws me off for using pivot table. Is there a way
to filter the table in a way that adds the values for repetitive months?