calculating
I am trying to create a timesheet using "v" for one vacation day and "1/2v" for a half of vacation day. function to count so that the total be 11/2 (one and a half) in a different cell. Do you have a function or functions I can use to do this. |
calculating
Hi,
You could try this =COUNTIF(A:A,"v")+COUNTIF(A:A,"1/2v")/2 change the column to suit. Mike "KANDLEZ" wrote: I am trying to create a timesheet using "v" for one vacation day and "1/2v" for a half of vacation day. function to count so that the total be 11/2 (one and a half) in a different cell. Do you have a function or functions I can use to do this. |
calculating
Maybe this:
=COUNTIF(B2:J2,"v")+COUNTIF(B2:J2,"1/2v")/2 -- Biff Microsoft Excel MVP "KANDLEZ" wrote in message ... I am trying to create a timesheet using "v" for one vacation day and "1/2v" for a half of vacation day. function to count so that the total be 11/2 (one and a half) in a different cell. Do you have a function or functions I can use to do this. |
calculating
THANK YOU! IT WORKS
-- KK "KANDLEZ" wrote: I am trying to create a timesheet using "v" for one vacation day and "1/2v" for a half of vacation day. function to count so that the total be 11/2 (one and a half) in a different cell. Do you have a function or functions I can use to do this. |
All times are GMT +1. The time now is 07:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com