Countifs function
Closed
bigmike
-
Apr 20, 2009 at 07:37 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 23, 2009 at 05:59 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 23, 2009 at 05:59 AM
Related:
- Countifs function
- Find function on mac - Guide
- Agp function - Guide
- Spreadsheet function - Guide
- Accessor function c++ - Guide
- Hard drive function - Guide
2 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Apr 21, 2009 at 11:10 PM
Apr 21, 2009 at 11:10 PM
Your question is confusing ..... do u mean to say , you have some cut of dates in sheet2!D4 and result in sheet2!E4 you wanna mention work is done or not ?????
Then in Sheet!1 you want to count work done in whole column of D & E ?????
Then in Sheet!1 you want to count work done in whole column of D & E ?????
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Apr 23, 2009 at 05:59 AM
Apr 23, 2009 at 05:59 AM
Can you email me your sheet on my email maziz@jgc-descon.com.pk
Apr 22, 2009 at 08:44 PM
On sheet 1 i need to count 1 in D5 each time the things on sheet 2 that are met that are as follows,
D4 says Pending
E4 has a date in it that i put in it such as 4/22/09 and if that date goes past 30 days (5/22/09)
These two things have to be met to be able to count 1 on sheet 1 D5
I hope this sounds right. I am trying to learn excel and it is such a great program but very hard for me to get the functions down. Thank you so much for your help. Mike