Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I was hoping for some help. I am a complete excel novice, and the
formula I require is probably quite basic compared to some! but hopefully someone can help. I have a column that is calculating the number of days taken for a particular task, based on dates input in other columns. I have formatted the column so that anything greater than 3 is highlighted in a colour red. What I am trying to do is at the bottom of the sheet, put a "total" cell in that will tell me how many rows have values that are greater than 3 (or coloured red), whichever is easier. Ie, trying to get the figure for how many instances the task has taken longer than 3 days. Thanks for any help you can give me. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Where you want your result, place this formula:
=Countif(E2:E7,"3") where E2:E7 is the range of data. " wrote: Hi, I was hoping for some help. I am a complete excel novice, and the formula I require is probably quite basic compared to some! but hopefully someone can help. I have a column that is calculating the number of days taken for a particular task, based on dates input in other columns. I have formatted the column so that anything greater than 3 is highlighted in a colour red. What I am trying to do is at the bottom of the sheet, put a "total" cell in that will tell me how many rows have values that are greater than 3 (or coloured red), whichever is easier. Ie, trying to get the figure for how many instances the task has taken longer than 3 days. Thanks for any help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|