Hi,

You can do this by using the CELL formula in a "helper" column (worth
looking CELL up in Excel Help).

Assuming data is in column A, enter:

=CELL("format",A1)

The formula will return "C2" for currency and "D1" for date format. You can
then use the sumif formula based on the codes returned.

Myles

"Starbuck82" wrote:

I have both dates and currency in the same column. How do I sum the column
based on format of the cell? Specifically, how do I sumif only the cells
containing currency?