Sum columns when is number

[ABC3132]

Hello.
I want to sum figures only when they are numbers, not dates or text.
Thanks in advance
EG:

Total	18
January	NONE
February	6
March	12
April	>From 15/4/24

 

[Joe4]

Note that the SUM function automatically ignores text.
Regarding dates, it depends on how they are entered into Excel.
Valid date entries in Excel REALLY are just numbers with special date formats applied (dates are stored in Excel as the number of days since 1/0/1900).
So any valid dates would be included in the SUM, but if they are entered as Text, they will not be.

In your example, since April has the word "From" in it, it is a text entry, so would not be picked up by the SUM function.
So the SUM function would return exactly 18 on your sample data.

 

[ABC3132]

Note that the SUM function automatically ignores text.
Regarding dates, it depends on how they are entered into Excel.
Valid date entries in Excel REALLY are just numbers with special date formats applied (dates are stored in Excel as the number of days since 1/0/1900).
So any valid dates would be included in the SUM, but if they are entered as Text, they will not be.

In your example, since April has the word "From" in it, it is a text entry, so would not be picked up by the SUM function.
So the SUM function would return exactly 18 on your sample data.

Thanks Joe4. You are right

 

[Joe4]

You are welcome!