| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I was wondering how to have excel have a specific number input | Excel Discussion (Misc queries) | |||
| How do I map the route of curser to specific input cells excel | Excel Discussion (Misc queries) | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| SaveAS to a specific folder, with operator input of file name | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
![Mohamed[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
