| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF vs COUNTIF
I have a column populated with dates. I want a cell in another worksheet to
count how many of the dates in the aforementioned column are less than a user defined date. I.e. I want the cell to display how many dates fall before 15th August. I am unsure as to how to write this correctly. Currently I have: =COUNTIF('Sheet1'!AH16:AH97, "<15/08/2005") Is this correct? What would SUMIF do in contrast? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
| problems with sumif and countif | Excel Discussion (Misc queries) | |||
| Reference Cells with Sumif or Countif | New Users to Excel | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
| Countif, Sumif, If - help! | Excel Worksheet Functions | |||
Threaded Mode
