| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to count formatted result value
In column A enter the date and in B a formula copies A1 reformated as day
(dddd). How can I count the results of colums "B" (number of times each day appears)? Col A Col B 1/1/10 9:13 PM Friday 1/3/10 3:25 PM Sunday |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to count formatted result value
=SUMPRODUCT(--(WEEKDAY(B$1:B$100)=ROW(A1)),--(B$1:B$100<"")) and copy down
through rows 1 to 7, will show the count for each day from Sunday to Saturday. -- David Biddulph "WD" wrote in message ... In column A enter the date and in B a formula copies A1 reformated as day (dddd). How can I count the results of colums "B" (number of times each day appears)? Col A Col B 1/1/10 9:13 PM Friday 1/3/10 3:25 PM Sunday |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to count formatted result value
hi
if B1 is friday and you wish to count friday, you can do 1 of 2 things..... =countif(B1:B200,"Friday") or if B1 is Friday then =countif(B1:B200,B1) some experts seem to think verison 2 is more reliable and it may be but it requires more advanced knowlege of what B1 will be. regards FSt1 "WD" wrote: In column A enter the date and in B a formula copies A1 reformated as day (dddd). How can I count the results of colums "B" (number of times each day appears)? Col A Col B 1/1/10 9:13 PM Friday 1/3/10 3:25 PM Sunday |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to count formatted result value
My reading of the question was that column B didn't contain text values such
as "Friday", but contained real dates formatted as dddd. -- David Biddulph "FSt1" wrote in message ... hi if B1 is friday and you wish to count friday, you can do 1 of 2 things..... =countif(B1:B200,"Friday") or if B1 is Friday then =countif(B1:B200,B1) some experts seem to think verison 2 is more reliable and it may be but it requires more advanced knowlege of what B1 will be. regards FSt1 "WD" wrote: In column A enter the date and in B a formula copies A1 reformated as day (dddd). How can I count the results of colums "B" (number of times each day appears)? Col A Col B 1/1/10 9:13 PM Friday 1/3/10 3:25 PM Sunday |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatted Result from an IF function | Excel Worksheet Functions | |||
| Count if within conditional formatted cells | Excel Worksheet Functions | |||
| Formula to count number of time stamps within a range in a column having dates formatted as "custom" | Excel Discussion (Misc queries) | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
Linear Mode
