Excel Formula Gurus - Help!
25 April 2006, 05:04 PM
#1
Scooby Regular
Thread Starter
Join Date: May 2000
Location: MY00,MY01,RX-8, Alfa 147 & Focus ST :-)
Posts: 10,371
Likes: 0
Received 0 Likes
on
0 Posts
Excel Formula Gurus - Help!
Here's an interesting one for you. Got a simple spreadsheet for working out holidays. Basically it is a grid 31 columns wide and 12 rows deep, representing a calendar year.
Each column is added by =COUNTIF(B3:B14,"H"), where 'H' = a holiday and counts as one. Can I adjust the forumla to add in another character that would represent a half day and therefore have a value of 0.5?
Does that make sense???
Chris
Each column is added by =COUNTIF(B3:B14,"H"), where 'H' = a holiday and counts as one. Can I adjust the forumla to add in another character that would represent a half day and therefore have a value of 0.5?
Does that make sense???
Chris
28 April 2006, 01:08 AM
#5
Originally Posted by bob269
=SUM(COUNTIF(B3:B14,"H")+((COUNTIF(B9:B14,"D")/2)))
Where D would be your half day character
Where D would be your half day character
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM