Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count/CountIF Formula
Hey folks, My latest endeaver has me stumped. I can't seem to figure out how to use the =COUNT or =COUNTIF formulas to accomplish what I need. I have a spreadsheet which holds three pieces of information per entry. This information is located in the following columns: D: Checklist Name E: Date Updated F: Path I have column C turn green, yellow, or red, using a conditional format if the 'date updated' (from column E) is within 6 month, in the 6th month, or greater then six month from Today(). The conditional format works great. The problem I am having, however is when I am trying to count the number of overdue/current/due for update checklists. For my 'due for update' checklists, I am using: (Today()-E2) = 181 and (Today()-E2) <= 211 I mentioned this incase people needed the dates caluclations I used. The only solution I can think of is to have excel display a certain character depending on what the update status is, then have a 2nd formula count all the occurances of that certain character. But there has to be a better way to do this? I don't want to have hidden columsn all over my spreadsheet for formulas I was unable to code properly. Can anyone point me in the right direction? Thanks in advanced. -- ph8 ------------------------------------------------------------------------ ph8's Profile: http://www.excelforum.com/member.php...o&userid=19871 View this thread: http://www.excelforum.com/showthread...hreadid=529982 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help with Count or Countif... | Excel Discussion (Misc queries) | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
How do I use CountIf formula to count a within a range of numbers | Excel Programming | |||
How do I use CountIf formula to count a within a range of numbers | Excel Programming | |||
Using the Lastrow variable in a Count/Countif formula | Excel Programming |