Column A Sales Month

So, what is the Sales Month? A date like 1/1/2007? The month number like 1
(for January)? A TEXT string like Jan? A DATE like 1/1/2007 formatted to
display like Jan?

Biff

"GatorGirl" wrote in message
...
I am trying to have a cell total figures if a cell in a different column
range is met.
Ex.
Column A Sales Month
Column B Sales Figure

Entries are made in random order so i want the total of sales for the
month
specified in a cell.

I looked at sumif but didn't seem to work because i need to include the
range of entries to get all of the specified month.

:)