LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Counting defined values

I am trying to count the number of times either "12 12" or "8 16" (these
being shift patterns) occur in a column. My table is set out in a calendar
format, with the value beside a persons name. I need to count how many times
there was 2 or less of the above values in one day, so I am assuming i should
count each column, then have a SUM at the end of it. My aim is to count how
many times in a year, there were days with 2 or less of the above values. ie
0, 1 or 2 people working that day. I have already set conditional formatting
so that these values are turned up in red, so I dont know if that helps,
(although other values in the table are red also!)

I am sorry if this is confusing, I am a bit of a novice user, and am VERY
confused! Ive tried to explain it a bit below.

Eg
A B C D E F G
1 2 3 4 5 6 7

Mr A 12 12 8 16 N/A N/A 8 16 N/A N/A
Mr B N/A 12 12 N/A 8 16 N/A 12 12 N/A
Mr C N/A 8 16 N/A 12 12 N/A 8 16 N/A

Therefore, column A is one, column B is 3, C is 0, D is 2 etc

I only want a total if there are 2 or less, so the above would be 6.

Any help would be appreciated!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Count Rows with defined values in multiple columns ryesworld Excel Worksheet Functions 9 November 8th 05 06:32 PM
counting rows with same values for multiple values Jon Viehe New Users to Excel 4 September 1st 05 03:49 PM
How to slot cell values into pre-defined ranges KDD Excel Discussion (Misc queries) 7 August 29th 05 03:34 PM
Counting rows, then counting values. Michael via OfficeKB.com Excel Discussion (Misc queries) 7 August 4th 05 10:57 PM
retrieving values between 2 defined limits in experimetal data series uriel78 Excel Discussion (Misc queries) 5 February 13th 05 11:36 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"