#### If Statement Help

```I'm trying to get this to work, and I'm wondering if an If statement is
the most efficent way.  Anyway.

In one row, I have various numbers corresponding to weeks, week #1,
week #2, week #3, etc.  In a row right below that, I have a number
corresponding to shipment quantity.

City          City 2        City 3
More Cities...
Arrival Week                1              3               1
Shipment Quantity     500           400           300

I'd like to see how many total arrivals I'll have in a certain week.
Week 1 should return 800 (500+300).  Week 2 should return 400.  Any
help would be greatly appreciated.

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

```
 0
9/14/2003 9:03:35 AM
excel 39879 articles. 2 followers.

3 Replies
559 Views

Similar Articles

[PageSpeed] 42

```RichC wrote:
> I'm trying to get this to work, and I'm wondering if an If statement
> is the most efficent way.  Anyway.
>
> In one row, I have various numbers corresponding to weeks, week #1,
> week #2, week #3, etc.  In a row right below that, I have a number
> corresponding to shipment quantity.
>
> City          City 2        City 3
> More Cities...
> Arrival Week                1              3               1
> Shipment Quantity     500           400           300
>
> I'd like to see how many total arrivals I'll have in a certain week.
> Week 1 should return 800 (500+300).  Week 2 should return 400.  Any
> help would be greatly appreciated.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from
> http://www.ExcelForum.com/

Sounds like SUMIF is your best bet...
--
The facts above belong to everybody; the opinions to me; the
distinction is yours to draw.

```
 0
me1 (409)
9/14/2003 11:11:05 AM
```The Red Cardinal wrote:

> Sounds like SUMIF is your best bet...

Sorry, it goes like this:

=SUMIF (Range of weeks, the criteria you want (e.g. 1), the range of
shipment quantities)

e.g.

= SUMIF (A2:I2, "=1", A3:I3)

Thus for every cell in A2:I2 which equals 1, it will return the value in the
corresponding 3rd row and add them together.

Hope this helps.

--
The facts above belong to everybody; the opinions to me; the
distinction is yours to draw.

```
 0
me1 (409)
9/14/2003 11:14:28 AM
```I'd suggest rearranging the data to the following:

City      ArrivalWeek   Qty
Toronto       1         500
Ottawa        2         400
Vancouver     3         300
Montreal      1         400

This will allow you to enter multiple shipments per city per week, if
required, and will make reporting easier.

To see your totals, create a PivotTable:

1. Select a cell in the table
2. Choose Data>PivotTable and PivotChart report
3. Click Next, click Next
4. Click the Layout button
5. Drag the City button to the Row area
6. Drag the Arrival Week button to the Column Area
7. Drag the Qty button to the Data area
8. Click OK, click Finish

RichC wrote:
> I'm trying to get this to work, and I'm wondering if an If statement is
> the most efficent way.  Anyway.
>
> In one row, I have various numbers corresponding to weeks, week #1,
> week #2, week #3, etc.  In a row right below that, I have a number
> corresponding to shipment quantity.
>
> City          City 2        City 3
> More Cities...
> Arrival Week                1              3               1
> Shipment Quantity     500           400           300
>
> I'd like to see how many total arrivals I'll have in a certain week.
> Week 1 should return 800 (500+300).  Week 2 should return 400.  Any
> help would be greatly appreciated.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

```
 0
dsd (439)
9/14/2003 11:28:04 AM

Similar Artilces:

flag for follow up Help
Using Microsoft Outlook 2000 SP-3. My Flag for Follow Up quit working, in my in box, but I can flag in other folders. Anyone else ever have this problem? Please advise. Thank you, Chris Jametski ...

New Outlook user needing help
After trying to sync my mobile phone & Pocket PC with Outlook 2000 on my computer the '+' prefix (i.e. + 44 1234 567890) which I have for all my telephone numbers do not show up in Outlook contacts. Even when I enter the '+' manually at the beginning of the number when I press save it disappears. What is most annoying of all is when I sync my phone with outlook again it even replaces all the numbers in my phone without the '+'. Can someone shed some light as to what settings I need to go into to resolve this problem...Many thanks ...

SQL statement in form text control
Hello! In a social services DB, one of the reports is all incidents involving a particular client. There are a few thousand records. I am using an SQL statement which filters records by the client's full name and Birthdate. The SQL is sent to the rowsource property of a combo box. The combination of name and DOB provides 1 unique client. (or none if the DOB is mis-entered or is wrong) The report (controlled by a query with parameters provided by the DOB text control and the combo box.) The combo box seems to be just one more thing to click through, so I thought of changi...

Need offset function help, I think
I have 10 products rows with a cost in column BW of rows 21 thru 30, i.e., cells BW21 down to BW30. Those 10 products have the # of units sold each month, for 22 months, shown in rows 41 thru 50, in columns E thru Z, so column E is month #1 ... col Z is month #22. The total range is cells E40 thru Z40. There is a cost factor vector that has six factors in row 70, cells G70 thru L70. These are to be used =91for all time periods=92 and for all products. Any time there is a sale of a product in a certain month, I want to enter six months of cost associated with producing the item...

How zoom/increase font size of Office 2004 "Help" text?
Font sizes can be set for Word, Excel and Entourage. You also can zoom in to enlarge the View of text in Office 2004 components� documents. How does one do this with the small-font text in Help? Respectfully, Norm On 9/14/04 1:36 AM, in article BD6BFBA9.49F3%nnager@vnoxsxpxaxmv.fullerton.edu, "Norman R. Nager, Ph.D." <nnager@vnoxsxpxaxmv.fullerton.edu> wrote: > Font sizes can be set for Word, Excel and Entourage. You also can zoom in > to enlarge the View of text in Office 2004 components� documents. > > How does one do this with the small-font text in Help...

I am trying to share out a users calander to a group of managers. When I go to properties on the calander it adds them ok. When I go to add them in the properties under the users mailbox in Outlook 2002 on Windows NT it gives me the message "The modified permission could not be saved. The client operation failed." I have read article 323611 on a workaround, but this did not work. We are using Exchange 2000, and I know when I started my predisesor was backing up the M drive on the Exchange server, so when I look at the security settings on the users box on the M drive it...

Help with Excel Workbook
I am updating a workbook and very behind. It's a construction workbook, so there many separate categories that have to total costs For example, electric, plumbing, misc....etc...and then theres a totals page. What is the easiest way to input info? Can I input all info on one page. thanks Not sure if this has anything to do with Outlook. You might have better luck posting in an Excel newsgroup. "Nina" <Nina@discussions.microsoft.com> wrote in message news:0E171EE5-5679-4210-9D00-E7649A0FB909@microsoft.com... >I am updating a workbook and very behind. It's a...

I want to create a formula for an employee schedule to compute the totals hrs scheduled, multiply total hrs scheduled by rate of pay to get a gross rate of pay. I can only get it to add up to 24 hrs then it starts over at 1. Example I am using: Start:17:00 End: 19:00 Total: =(end-start) =IF(A3<A2,A3+1-A2,A3-A2)*24*B2 Where A2 is start, A3 is finished, B2 is rate of pay Format cell to currency or accounting. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Dave" wrote: > I want to create a formula for an employee schedule to co...

New to excel Help
hello I am new to this forum and not good with excel. this is a brief explaination of what i need to do to kick things off. hop somebosy can help have a calculation for temperature that i have 25 deg figures for. need to be able to create a excel calculation for any given value (i deg). I have a table of values run from a line of best fit basis. so far my equation is eg D1=(A1*B1)*C1 F1=D1/ratio in table pre determinded by the temp in E1 Can anybody help Scott sdminus@yahoo.co.u -- swa ----------------------------------------------------------------------- sway's Profile: http...

Frank Kabel...need your help
I've got MSQuery setup to retrieve data from an external database. I have a macro that automatically refreshes the data when the file is open. It's very cool because I've got it setup to prompt for the parameters (e.g., beginning date, ending date) I'd like to complete the automation of this spreadsheet by telling Excel to refresh all the pivot tables in this workbook, AFTER the data is DONE being downloaded. Hi Jonathan first: you may use a different header for this kind of postings: Just stae your problem and don't address a question directly to one of the regulars....

I have all my personal banking, credit card numbers, passwords, drivers license #, ect, on in my contacts. And some sensitive info in notes. My company just changed to an inhouse server and is using ms exchange and it copied my contacts folder to the server, which can certainly be viewed by anybody in the office. And I run the risk of all this going everywhere. I went on the internet site and deleted everything I could, but now I can never go into outlook while being connected to the internet. Please help! What is the best solution? Thanks, Wendy Mark your contact properties in the permissi...

pivot table help #2
I am extremely new to pivot tables and trying to just get ave, max, and min of a couple of columns ... I keep getting #DIV/0! errors and don't know what the problem is. any ideas anyone??? -- evg1 ------------------------------------------------------------------------ evg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35043 View this thread: http://www.excelforum.com/showthread.php?threadid=547887 Do you have errors in any of those fields in the raw data? Do you have any numbers in the field that you're averaging? evg1 wrote: > > I am ...

network key pw help
I have forgotten my network key pw for my wireless router my lap top has the pw saved so i can get onwith that pc but i need the pw so i connect with another lap to is there any way to retrive this pw??? I am useing the window connection for connection Thanks Mike Mike <Mike@discussions.microsoft.com> wrote: >I have forgotten my network key pw for my wireless router >my lap top has the pw saved so i can get onwith that pc but i need the pw so >i connect with another lap to is there any way to retrive this pw??? I am >useing the window connection for connection You wi...

help-planning
We carry circa 25 products. Each product needs to be processed in 2-3 stages. circa 20 minutes/ stage. Raw materials come in several times a month. However for some products the raw materials are readily available while for others 1-2 months are necessary. Each product is packaged differently. Each consignment consists of a product mix. (between 1 and 25) There are circa 5 large customers (2000 products/month) , 5 medium ones (200/ month) and 10 small ones (20/month). (but none of these order every single month). At the moment most customers need to wait circa 2 months but the planning must be...

What is wrong with this IF statement? need help.
This statement works fine but I want the cell to say 0" if the cell H6 has a zero in it. As the stetments stands right now it displayes 6" in the cell if H6 is 0. How can I make that happen? =IF(H6<101,"6""",IF(AND(H6>101.1,H6<151),"7""",IF(AND(H6>151.1,H6<201),"8""",IF(AND(H6>200.1,H6<275.1),"9""",IF(AND(H6>275.2,H6<350.1),"10""",IF(AND(H6>350.2,H6<601),"12""",IF(AND(H6>601.1,H6<901),"14"""))))))) Pleas...

Hello! I have a nice problem for you - so please help me! I have a property sheet with three pages in it. I make a pointer to the doc class. I receive a value from the doc class. When I�'m going to use that value - the value has changed, so I receive an exception. How can I get the right value from the doc class? Is a doc class' value a word or a dword? -- - Lars The doc class reference is a pointer. It is not a word, and it is not a dword, it is an address. This means it could be 64 bits on a 64-bit machine. Never assume that a pointer is 32 bits. The pointer to a CDocume...

Loven test for there help
...

Need some help from you smart people...
I have a spreadsheet that has multiple columns (13) that are variou milestones. These columns contain dates that range over a period o time given in day, month and year (11/18/2003). My question is, how ca I filter, sort, etc...by a given date range i.e. for a 3 month period? I hope that this is clear enough to get some feedback. Thank you. Healu ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com If I understand your intent, you need to use Data > Filter >AutoFilter....

I have an Exchange 2003 and I needed to create aliases that would forward to several external email address (like jdoe@localdomain.com forwarding to jdoe@yahoo.com). What I did was to create a user named buttler@localdomain.com, assigned all the aliases to it (jdoe, janedoe, somebody and help) and create rules that will redirect based on "Sent to" to the external addresses. For better understanding of my problem I post two examples below: Apply this rule after the message arrives sent to jdoe@localdomain.com redirect to jdoe@yahoo.com and delete it and stop processing more rules A...

Help! Need to add/delete email users
We are a nonprofit in a sticky situation - our old consultants are terrible and we are replacing them next week, but in the meantime I have a new assistant starting on Monday and need to get rid of the old assistant's email/login and set her up. I am the most skilled at computers in our office unfortunately, and am in the network room (luckily it is logged on) but have no idea where to find a place to change it or how to change it. I am guessing its not too difficult if I'm pointed in the right direction. We can't have the original consultants come in to do this so any...

Can not receive Email.. Need Help
Hi all, Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just stopped receiving external e-mail. We can send interoffice e-mails and we can send out e-mails to other locations fine, but we are unable to receive any e-mail. All internet connections are normal as well, and the port 25 is open on the firewall. The error from when we try to send an e-mail to the server is this: “This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed.” Earlier today I installed the anti-spam update from MS “Microsoft excha...