#### SUMIFS help

```Hi.  Hope you’re able to help.  I’m having difficulties the SUMIFS function.
Either I’m using it incorrectly or perhaps it’s the wrong function for me!

I’m trying to total the money amounts in column E as long as conditions in
columns A (cell A6 in this example) and column H are True.  However, I’m
finding that the function is not totalling up the money amounts it should be
totalling in column E.  Instead, it’s just returning a single money amount in
column E and ignoring the rest!  This is the function as I’ve written it:

=SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!H3:H1000,"*102")

So, I’m trying to add-up any money amounts in column E as long as the
condition in column A (cell A6 in this example) is true and column H contains
102.

I’m not sure if this helps, but I do have another column (column D) that
names each unique cheque number.  Just thought I’d let you know that in case
I’m confusing the function in some way and it might expect some form of
uniqueness.

--
Peter
```
 0
Utf
3/4/2010 9:32:01 AM
excel.worksheet.functions 4936 articles. 2 followers.

3 Replies
551 Views

Similar Articles

[PageSpeed] 15

```I juts tried it and it worked fine.

--

HTH

Bob

"Peter" <peter@discussions.microsoft.com> wrote in message
news:504076AF-ECB2-4E47-BBD9-ED22C003711D@microsoft.com...
> Hi.  Hope you're able to help.  I'm having difficulties the SUMIFS
> function.
> Either I'm using it incorrectly or perhaps it's the wrong function for me!
>
> I'm trying to total the money amounts in column E as long as conditions in
> columns A (cell A6 in this example) and column H are True.  However, I'm
> finding that the function is not totalling up the money amounts it should
> be
> totalling in column E.  Instead, it's just returning a single money amount
> in
> column E and ignoring the rest!  This is the function as I've written it:
>
> =SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!H3:H1000,"*102")
>
> So, I'm trying to add-up any money amounts in column E as long as the
> condition in column A (cell A6 in this example) is true and column H
> contains
> 102.
>
> I'm not sure if this helps, but I do have another column (column D) that
> names each unique cheque number.  Just thought I'd let you know that in
> case
> I'm confusing the function in some way and it might expect some form of
> uniqueness.
>
> --
> Peter

```
 0
Bob
3/4/2010 12:20:03 PM
```Hello Bob
I'm so grateful you took the time to look at this.  The fact that it worked
for you made me re-visit my sheet.  I discovered an error I had introduced
myself in a related formula!  So, many thanks for the sanity check.  All
fixed now.
cheers again.
--
Peter

"Bob Phillips" wrote:

> I juts tried it and it worked fine.
>
> --
>
> HTH
>
> Bob
>
> "Peter" <peter@discussions.microsoft.com> wrote in message
> news:504076AF-ECB2-4E47-BBD9-ED22C003711D@microsoft.com...
> > Hi.  Hope you're able to help.  I'm having difficulties the SUMIFS
> > function.
> > Either I'm using it incorrectly or perhaps it's the wrong function for me!
> >
> > I'm trying to total the money amounts in column E as long as conditions in
> > columns A (cell A6 in this example) and column H are True.  However, I'm
> > finding that the function is not totalling up the money amounts it should
> > be
> > totalling in column E.  Instead, it's just returning a single money amount
> > in
> > column E and ignoring the rest!  This is the function as I've written it:
> >
> > =SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!H3:H1000,"*102")
> >
> > So, I'm trying to add-up any money amounts in column E as long as the
> > condition in column A (cell A6 in this example) is true and column H
> > contains
> > 102.
> >
> > I'm not sure if this helps, but I do have another column (column D) that
> > names each unique cheque number.  Just thought I'd let you know that in
> > case
> > I'm confusing the function in some way and it might expect some form of
> > uniqueness.
> >
> > --
> > Peter
>
>
> .
>
```
 0
Utf
3/4/2010 2:07:02 PM
```Thanks for that Peter. I have often wondered whether such responses are
worthwhile, you have encouraged me :)

--

HTH

Bob

"Peter" <peter@discussions.microsoft.com> wrote in message
news:12F8591D-418A-4824-B07D-7462170E4BBB@microsoft.com...
> Hello Bob
> I'm so grateful you took the time to look at this.  The fact that it
> worked
> for you made me re-visit my sheet.  I discovered an error I had introduced
> myself in a related formula!  So, many thanks for the sanity check.  All
> fixed now.
> cheers again.
> --
> Peter
>
>
> "Bob Phillips" wrote:
>
>> I juts tried it and it worked fine.
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Peter" <peter@discussions.microsoft.com> wrote in message
>> news:504076AF-ECB2-4E47-BBD9-ED22C003711D@microsoft.com...
>> > Hi.  Hope you're able to help.  I'm having difficulties the SUMIFS
>> > function.
>> > Either I'm using it incorrectly or perhaps it's the wrong function for
>> > me!
>> >
>> > I'm trying to total the money amounts in column E as long as conditions
>> > in
>> > columns A (cell A6 in this example) and column H are True.  However,
>> > I'm
>> > finding that the function is not totalling up the money amounts it
>> > should
>> > be
>> > totalling in column E.  Instead, it's just returning a single money
>> > amount
>> > in
>> > column E and ignoring the rest!  This is the function as I've written
>> > it:
>> >
>> > =SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!H3:H1000,"*102")
>> >
>> > So, I'm trying to add-up any money amounts in column E as long as the
>> > condition in column A (cell A6 in this example) is true and column H
>> > contains
>> > 102.
>> >
>> > I'm not sure if this helps, but I do have another column (column D)
>> > that
>> > names each unique cheque number.  Just thought I'd let you know that in
>> > case
>> > I'm confusing the function in some way and it might expect some form of
>> > uniqueness.
>> >
>> > --
>> > Peter
>>
>>
>> .
>>

```
 0
Bob
3/4/2010 11:27:13 PM

Similar Artilces:

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

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

Why won't ADDRESS work nested inside SUMIF?
If I do this: =ADDRESS(4,MATCH(E37,A2:JW2,0)) I get: \$L\$4 If I do: =SUMIF(A3:JW3,"Units",ADDRESS(4,MATCH(E37,A2:JW2,0)):JW4) I get an error. However if I do: =SUMIF(A3:JW3,"Units",INDIRECT(G1):JW4) I get the answer I want. However, I'd prefer to not have a helper cell. Please help! Some lateral thoughts, with emphasis on resolving the core issues you raised in your other, earlier thread Let's say you have col data in groups of 3 cols, with headers in row2 (eg: Period1, Period2, etc), where each header is placed only in the l...

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

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

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

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

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