sum function with ignore

[juan1]

How to sum a long column but ignore numerous date cells in the column.
thank for any help
Juan

 

[mikerickson]

You can do this with a helper column.

If your data is in A1:A1000, put =CELL("Format",A1) in B1 and drag down.

Then the formula =SUM(A1:A1000)-SUMIF(B1:B1000, "d*", A1:A1000) will return the sum of the cells in column A that are not formatted for dates.

 

[juan1]

Thank you