Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to do a countif - want cells that are before or on a certain dateand do not want to hard code that date
hi - i need to do a countif function that will count all the cells
that have a date on or before a certain date. i have a spreadsheet at the very beginning that has this threshold date and want to reference that cell in the count if function because it may be changing. i have tried : countif(firstcell:last cell,<=Worksheet1A1) and have included paratheses but it always returns zero. both the reference cell and the range with dates are set to mm/dd/yyyy. Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to do a countif - want cells that are before or on a certain d
=COUNTIF(B:B,"<="&A1)
-- Gary''s Student - gsnu2007k |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hard code date in excel . . . | Excel Discussion (Misc queries) | |||
Hard code month in Excel | Excel Discussion (Misc queries) | |||
Not Hard Code If | Excel Discussion (Misc queries) | |||
Hard-code source data | Charts and Charting in Excel | |||
Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) |