Search results for query: *

THANKS AGAIN....

thanks, I tried the sumproduct but I must have done somthing wrong....when i copied and pasted yours, it works...GREAT..

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...

Thank you for the direction, I found one of your replies that helped. Thanks again

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...

I have tried all suggestions and was left with nothing or the decimal that I explained above. I will keep trying..thanks

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...

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...

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

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...

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...

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

I need a formula...I don'think pivot tables will do what I need thanks for the thought

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...

Fee Yes that is what I need to do...please let me know your method... Thanks

i USED THIS WHICH WORKED BUT i NEED TO ALSO SUM BY SPECIFIC DATE =SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1)) a B SMITH 1/13/06 JONES 1/13/06 ROSS 2/10/06 SMITH 2/10/06 SMITH...

I have a spreadsheet with patients and need to sum the number of patients but some patients may be entered multiple times.See below A Smith Jones SMith Michaels Rogers Smith I need my result to be 4 not 6

I have a workbook with multiple sheets that have some protected cells. Is there a way to password protect all sheets at once...instead of each sheet individually

Thanks....you have helped me again...

HI, I have a table see below. I need to count how many times "4 Monti" occurs in Jan. If column A was just "Jan" I understand how to do it but how do I do it with the dates in this format....please help... A B 1/16/06 2 cohen 1/12/06 4 Monti 1/6/06 4 monti 5/12/06 ccu...