I
ian_ni
i am currently using a basic weekly diary in excel and need a formula that
will count cells which contain numbers along with text
Row 1 -> w/c 12/7/09 12/14/09 12/21/09 12/28/09 Total
13 days
I need formula that will give total of days across each month as above not
sure if countif formula will work for this or not
each cell will have the number of days used in that week followed by initial
of the day I need the formula to count the number that is at the start of the
text e.g 3mtw
is this possible to do?
will count cells which contain numbers along with text
Row 1 -> w/c 12/7/09 12/14/09 12/21/09 12/28/09 Total
days 3mtw 5 1w 4mtwtCol A
13 days
I need formula that will give total of days across each month as above not
sure if countif formula will work for this or not
each cell will have the number of days used in that week followed by initial
of the day I need the formula to count the number that is at the start of the
text e.g 3mtw
is this possible to do?