microsoft.public.excel.worksheet.functions | Forum profile

  Hi, You can download a list of the states and their abbreviations from http://www.usps.com/ncsc/lookups/usps_abbreviations.html If this helps, please click the Yes button Cheers, Shane Devenshire "Terry Berry" wrote: > I have a database that includes states and district numbers in separate > fields. I need to take those 2 fields and change them to a third combined > listing. > For...

  >i need to total the freight from the USD accounts only as well All USD accounts or just those that are type "sales" ? As long as the location of "freight" has a consistent offset, 1 row below, 2 columns to the right. Array entered** : =SUM(IF(A2:A16="USD",OFFSET(A2:A16,1,2))) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just...

  SUMPRODUCT seems to be what you may be looking for: =SUMPRODUCT(--(C1:C50="x"),--(D1:D50="y"),(A1:A50)) -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "Steve sivaD" wrote: > Hi, > > I already use the SUMIF function to calculate the total mileage for a > vehicle stored in columns A1:A50 if...

  Welcome, Yossy, and thanks for the rating! -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:362 Subscribers:64 xdemechanik --- "Yossy" <Yossy@discussions.microsoft.com> wrote in message news:5976CD6A-393F-4292-9566-CF071552646E@microsoft.com... > Thanks Shane and Max. This really helps!!! and Yes I clicked the Yes > button  

  Hi, If I understand correctly you want to calculate basic hours up to 48 and overtime hours for each person. Basic hours in I2 and drag down =MIN(48,(COUNTIF(B2:H2,"D")+COUNTIF(B2:H2,"N")+COUNTIF(B2:H2,"VA D")+COUNTIF(B2:H2,"VA-N"))*12) Overtime hours in J2 and drag down...

  :-) Glad it worked out... "PSRumbagh" wrote: > I tried this before without any luck. I forgot to use the "shift key" along > with the left mouse button to select the pair of cells to drag. Thanks, > everything works OK now. > "Sheeloo" wrote: > > > Enter 0 in A1 > > 9 in A2 > > =A1+10 in A3 >...

  You are assigning... Date & Time in the 2nd line of the subroutine. This butts up the date next to the time with nothing between them... Excel won't see that as a date/time combination. You need a space between them. Try assigning this instead... Date & " " & Time I think you will then be able to format the cell any way that you want. -- Rick (MVP - Excel) "Keyrookie"...

  I don't know the function FRAC but whatever it is the syntax should be: =INT(A2)+INT(FRAC(A2*100)/60)+FRAC(FRAC(A2*100))/36 Reasoning: You choose one cell to hold your variable x, say A2. Thus your formula refers to A2 wherever there is an x. I don;t know what you mean exactly and this determines the parentheses. For example, in your second term: int (frac x*100)/60 If you mean that you divide the result of INT with 60 then...

  say our data in A1 thru B100: 8/1/2007 $134.00 9/1/2007 $109.00 10/1/2007 $176.00 11/1/2007 $117.00 12/1/2007 $122.00 1/1/2008 $126.00 2/1/2008 $123.00 3/1/2008 $168.00 4/1/2008 $141.00 5/1/2008 $127.00 6/1/2008 $140.00 7/1/2008 $151.00 8/1/2008 $180.00 9/1/2008 $172.00 10/1/2008 $167.00 11/1/2008 $181.00 Now we only want year-to-date. In another cell: =SUMPRODUCT((YEAR(A1:A100)=2008)*(B1:B100)) displays 1676 because 2007 values...

  If you have data in more than one sheet and you want to include it in one series in a chart, the easiest way is to use a spreadsheet to pull the data together into one range in the spreadsheet, then plot from there. -- David Biddulph "Walley" <Walley@discussions.microsoft.com> wrote in message news:98C41DC1-84FA-498F-BA22-971F4EBBDF21@microsoft.com... > Hi > I have 3 excel sheets with...