Ask Your Question
0

I need a way to detect if a field is a date in a sumif expression. Help?

asked 2020-06-20 15:31:38 +0200

Al Vesper gravatar image

I need a way to detect if a field is a date in a sumif expression. Column X contains numbers, column Y MAY contain a date. If column Y has a date in it (otherwise blank), add the column X amount. =SUMIF(Y3:Y75, ?criteria? ,X3:X75)

ADV Thanks!!! ANCE

Al

edit retag flag offensive close merge delete

Comments

1

There is no special data type Date, hence you can't detect a date. Dates are integer numbers counting (better: indicating) the days since 1899-12-30 - see OASIS ODF Documentation - 4.3.3 Date. What you see in a date-formatted cell is a representation of that integer.

Opaque gravatar imageOpaque ( 2020-06-20 15:39:26 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-06-20 16:39:09 +0200

Al Vesper gravatar image

... as Opaque says, a date is a number, so the criteria I was looking for can be simply ">0" (with the double quotes), and (blush) don't forget to format the cell containing the answer properly...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-06-20 15:31:38 +0200

Seen: 20 times

Last updated: Jun 20