LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 47
Default Need help of you people

Hope you all would be fine. I am making a Mess Management sheet for employees
but i have a problem that i make "P" for present in mess and "a" for absent
before anyone's name according to date i count all "p" and all "a" by COUNTIF
but the problem is how to make the value of 2p twice if some one has guest
with him when in geting total of all presents(p).
plz guide urgently
Thanks alot
 
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
Why do people use SUM() unnecessarily? [email protected] Excel Discussion (Misc queries) 20 May 20th 06 07:21 PM
Hi people views once what I received: Money salary - program Excel Worksheet Functions 0 April 18th 06 05:35 PM
Hi people views once what I received: Money salary - program Excel Discussion (Misc queries) 0 April 18th 06 05:35 PM
Two People Using Same File crwiseman Excel Worksheet Functions 1 March 24th 06 08:24 PM
Calculating number of people Denise Excel Discussion (Misc queries) 2 January 10th 06 05:50 PM


All times are GMT +1. The time now is 11:13 PM.

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"