Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dr772
-
-
sum cells based on multiple conditions
thanks, I tried the sumproduct but I must have done somthing wrong....when i copied and pasted yours, it works...GREAT..- dr772
- Post #3
- Forum: Microsoft: Office
-
sum cells based on multiple conditions
Spreadsheet Date Unit Minutes 1/1/08 2M 40 2/5/08 4M 15 2/7 5M 10 I tried but is doesn't use the conditions I put in, it just gives me a total of 65. FORMULA...- dr772
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
COUNT BASED ON MULTIPLE CRITERIA
Thank you for the direction, I found one of your replies that helped. Thanks again- dr772
- Post #3
- Forum: Microsoft: Office
-
COUNT BASED ON MULTIPLE CRITERIA
I have a spreadsheet(sample) date unit name reason day eve night 2/8 4 Monti smith self float OT 2/9 4 Monti jones self OT 2/9 4 Monti smith self OT 2/9 2DSU doe OT self I...- dr772
- Thread
- Replies: 2
- Forum: Microsoft: Office
-
Count uniques with a condition
I have tried all suggestions and was left with nothing or the decimal that I explained above. I will keep trying..thanks- dr772
- Post #9
- Forum: Microsoft: Office
-
Count uniques with a condition
yes it worked for this controlled data but when I included another payperiod it doesn't work. I get 23.2 for 2/10/2007. See data below same headers 2/10/07 2/8/07 sicu 502bw o'dowd 2/10/07 2/8/07 picu 307b mayorga 2/10/07 2/8/07 nscu bed 2 bowen 2/10/07 2/8/07 ctu bed16 karides 2/10/07 2/8/07...- dr772
- Post #3
- Forum: Microsoft: Office
-
Count uniques with a condition
I have tried the below formula given to me yesterday...but am getting a decimal number...see data below I want to count unique names for a certain payperiod (this data doesn't show it but there may be different payperiods in the list. G2 being a reference to a payperiod on another sheet i.e...- dr772
- Thread
- Replies: 8
- Forum: Microsoft: Office
-
Sum uniques based on a condition
still not working...what does that dummy column do...I gave you an abreviated version of my data there are a few columns between payperiod and name.... This is frustrating Also xhlep I tried your and it gave me the same value as Glenn's...I will keep trying THanks- dr772
- Post #13
- Forum: Microsoft: Office
-
Sum uniques based on a condition
Glenn, (A) (B) (C) Payperiod ending Units NAME (row 2) 2/10/2007 sicu o'dowd 2/10/2007 picu mayorga 2/10/2007 nscu bowen 2/10/2007 ctu karides 2/10/2007 5 monti hills 2/10/2007 4 monti golin 2/10/2007 4 cohen...- dr772
- Post #11
- Forum: Microsoft: Office
-
Sum uniques based on a condition
Yes contains the date 2/10 and is entered as array (cntrl shift enter)I get a number not an error but it is not the right number. uhhh...- dr772
- Post #8
- Forum: Microsoft: Office
-
Sum uniques based on a condition
Glenn, I tried it, it looks as if it should work but I am not getting the correct results. any other thoughts I am determined to get a formula that works Thanks Diane- dr772
- Post #6
- Forum: Microsoft: Office
-
Sum uniques based on a condition
I need a formula...I don'think pivot tables will do what I need thanks for the thought- dr772
- Post #3
- Forum: Microsoft: Office
-
Sum uniques based on a condition
I have a spreadsheet that I need to count uniques during a payperiod see below A F 2/10 2 2/10 2 2/10 10 2/24 3 2/24 5 2/24 5 2/24 1 I am able to count the uniques with the following...- dr772
- Thread
- Replies: 15
- Forum: Microsoft: Office
-
Sum column with duplicate data
Fee Yes that is what I need to do...please let me know your method... Thanks- dr772
- Post #7
- Forum: Microsoft: Office
