ExcelBanter - Date Specific Input

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date Specific Input (https://www.excelbanter.com/excel-programming/288207-date-specific-input.html)

Mohamed[_3_]

Date Specific Input

Hi,

I hope this I named the subject better. Anyhow, I tried
the SUMIF function, did not work. Here is my equation.
Please refer to previous posting for exact situation.
Still need help!

=SUMIF(A3:A23,"=TODAY()",Sheet1!C31)

geo

Date Specific Input

=SUMIF(A3:A23,TODAY(),Sheet1!C31)
but this may make more sense:
=SUMIF(A3:A23,TODAY(),B3:B23) if you have a count of the
number of hours you worked in column B, or something

-----Original Message-----
Hi,

I hope this I named the subject better. Anyhow, I tried
the SUMIF function, did not work. Here is my equation.
Please refer to previous posting for exact situation.
Still need help!

=SUMIF(A3:A23,"=TODAY()",Sheet1!C31)

.

All times are GMT +1. The time now is 10:17 AM.