sum function with ignore

juan1

New Member
Joined
May 17, 2017
Messages
46
How to sum a long column but ignore numerous date cells in the column.
thank for any help
Juan
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,781
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,118
Messages
5,526,925
Members
409,730
Latest member
mimipiz

This Week's Hot Topics

Top