#### Sum Multiple Criteria 11-18-09

```Hello Everyone,

I have been try to learn how to use the SUM function with multiple criteria.
I have run into a road block with my experimentation.  By the way, I am
using Excel 2003 SP3.  My data looks like the following:

city	Mfr	model	volume
dearborn	ford	taurus	10
troy	ford	fusion	20
shelby	gm	lacrosse	10
warren	chrysler	sebring	10
dearborn	gm	camaro	30
detroit	ford	fusion	40
shelby	chrysler	magnum	20
warren	chrysler	avenger	40
troy	chrysler	avenger	20
detroit	gm	lacrosse	50
detroit	gm	impala	30
warren	ford	fusion	40
troy	chrysler	avenger	20
detroit	ford	taurus	10

The formula I am having a problem with is:

{=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}

The Sumprduct yields 120 as the answer which is correct but the formula
above yields 355 as the answer.  What am I missing?

John
```
 0
Utf
11/18/2009 3:30:01 PM
excel.worksheet.functions 4936 articles. 2 followers.

7 Replies
799 Views

Similar Articles

[PageSpeed] 33

```=SUMPRODUCT((C5:C18={"taurus","fusion"})*D5:D18)
Need NOT be array entered

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"JCS" <JCS@discussions.microsoft.com> wrote in message
news:1884C168-4935-4CC3-AE9B-F103EDBF6354@microsoft.com...
> Hello Everyone,
>
> I have been try to learn how to use the SUM function with multiple
> criteria.
> I have run into a road block with my experimentation.  By the way, I am
> using Excel 2003 SP3.  My data looks like the following:
>
> city Mfr model volume
> dearborn ford taurus 10
> troy ford fusion 20
> shelby gm lacrosse 10
> warren chrysler sebring 10
> dearborn gm camaro 30
> detroit ford fusion 40
> shelby chrysler magnum 20
> warren chrysler avenger 40
> troy chrysler avenger 20
> detroit gm lacrosse 50
> detroit gm impala 30
> warren ford fusion 40
> troy chrysler avenger 20
> detroit ford taurus 10
>
> The formula I am having a problem with is:
>
> {=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}
>
> The Sumprduct yields 120 as the answer which is correct but the formula
> above yields 355 as the answer.  What am I missing?
>
> John

```
 0
Don
11/18/2009 3:41:48 PM
```'array entered
=SUM((ISNUMBER(SEARCH({"taurus","fusion"},\$C\$5:\$C\$18)))*\$D\$5:\$D\$18)

OR
=SUMPRODUCT((ISNUMBER(SEARCH({"taurus","fusion"},
\$C\$5:\$C\$18)))*\$D\$5:\$D\$18)

If this post helps click Yes
---------------
Jacob Skaria

"JCS" wrote:

> Hello Everyone,
>
> I have been try to learn how to use the SUM function with multiple criteria.
>  I have run into a road block with my experimentation.  By the way, I am
> using Excel 2003 SP3.  My data looks like the following:
>
> city	Mfr	model	volume
> dearborn	ford	taurus	10
> troy	ford	fusion	20
> shelby	gm	lacrosse	10
> warren	chrysler	sebring	10
> dearborn	gm	camaro	30
> detroit	ford	fusion	40
> shelby	chrysler	magnum	20
> warren	chrysler	avenger	40
> troy	chrysler	avenger	20
> detroit	gm	lacrosse	50
> detroit	gm	impala	30
> warren	ford	fusion	40
> troy	chrysler	avenger	20
> detroit	ford	taurus	10
>
> The formula I am having a problem with is:
>
> {=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}
>
> The Sumprduct yields 120 as the answer which is correct but the formula
> above yields 355 as the answer.  What am I missing?
>
> John
```
 0
Utf
11/18/2009 3:44:01 PM
```Thank you Jacob,

So, according to your solution, my solution is not possible.

John

"Jacob Skaria" wrote:

> 'array entered
> =SUM((ISNUMBER(SEARCH({"taurus","fusion"},\$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
>
> OR
> =SUMPRODUCT((ISNUMBER(SEARCH({"taurus","fusion"},
> \$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "JCS" wrote:
>
> > Hello Everyone,
> >
> > I have been try to learn how to use the SUM function with multiple criteria.
> >  I have run into a road block with my experimentation.  By the way, I am
> > using Excel 2003 SP3.  My data looks like the following:
> >
> > city	Mfr	model	volume
> > dearborn	ford	taurus	10
> > troy	ford	fusion	20
> > shelby	gm	lacrosse	10
> > warren	chrysler	sebring	10
> > dearborn	gm	camaro	30
> > detroit	ford	fusion	40
> > shelby	chrysler	magnum	20
> > warren	chrysler	avenger	40
> > troy	chrysler	avenger	20
> > detroit	gm	lacrosse	50
> > detroit	gm	impala	30
> > warren	ford	fusion	40
> > troy	chrysler	avenger	20
> > detroit	ford	taurus	10
> >
> > The formula I am having a problem with is:
> >
> > {=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}
> >
> > The Sumprduct yields 120 as the answer which is correct but the formula
> > above yields 355 as the answer.  What am I missing?
> >
> > John
```
 0
Utf
11/18/2009 3:47:02 PM
```What your formula does is

=sum(count number of 'taurus'+ count number of 'fusion' + the array D5:D18)
=sum(2+3+350)
=355

If this post helps click Yes
---------------
Jacob Skaria

"JCS" wrote:

> Thank you Jacob,
>
> So, according to your solution, my solution is not possible.
>
> John
>
> "Jacob Skaria" wrote:
>
> > 'array entered
> > =SUM((ISNUMBER(SEARCH({"taurus","fusion"},\$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
> >
> > OR
> > =SUMPRODUCT((ISNUMBER(SEARCH({"taurus","fusion"},
> > \$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "JCS" wrote:
> >
> > > Hello Everyone,
> > >
> > > I have been try to learn how to use the SUM function with multiple criteria.
> > >  I have run into a road block with my experimentation.  By the way, I am
> > > using Excel 2003 SP3.  My data looks like the following:
> > >
> > > city	Mfr	model	volume
> > > dearborn	ford	taurus	10
> > > troy	ford	fusion	20
> > > shelby	gm	lacrosse	10
> > > warren	chrysler	sebring	10
> > > dearborn	gm	camaro	30
> > > detroit	ford	fusion	40
> > > shelby	chrysler	magnum	20
> > > warren	chrysler	avenger	40
> > > troy	chrysler	avenger	20
> > > detroit	gm	lacrosse	50
> > > detroit	gm	impala	30
> > > warren	ford	fusion	40
> > > troy	chrysler	avenger	20
> > > detroit	ford	taurus	10
> > >
> > > The formula I am having a problem with is:
> > >
> > > {=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}
> > >
> > > The Sumprduct yields 120 as the answer which is correct but the formula
> > > above yields 355 as the answer.  What am I missing?
> > >
> > > Thanx in advance,
> > > John
```
 0
Utf
11/18/2009 3:55:04 PM
```Thanks again Jacob,

You gave me exactly what i was looking for.  I was looking for the why my
formula was not working.  Thank you so much!

John

"Jacob Skaria" wrote:

> What your formula does is
>
> =sum(count number of 'taurus'+ count number of 'fusion' + the array D5:D18)
> =sum(2+3+350)
> =355
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "JCS" wrote:
>
> > Thank you Jacob,
> >
> > So, according to your solution, my solution is not possible.
> >
> > John
> >
> > "Jacob Skaria" wrote:
> >
> > > 'array entered
> > > =SUM((ISNUMBER(SEARCH({"taurus","fusion"},\$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
> > >
> > > OR
> > > =SUMPRODUCT((ISNUMBER(SEARCH({"taurus","fusion"},
> > > \$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
> > >
> > > If this post helps click Yes
> > > ---------------
> > > Jacob Skaria
> > >
> > >
> > > "JCS" wrote:
> > >
> > > > Hello Everyone,
> > > >
> > > > I have been try to learn how to use the SUM function with multiple criteria.
> > > >  I have run into a road block with my experimentation.  By the way, I am
> > > > using Excel 2003 SP3.  My data looks like the following:
> > > >
> > > > city	Mfr	model	volume
> > > > dearborn	ford	taurus	10
> > > > troy	ford	fusion	20
> > > > shelby	gm	lacrosse	10
> > > > warren	chrysler	sebring	10
> > > > dearborn	gm	camaro	30
> > > > detroit	ford	fusion	40
> > > > shelby	chrysler	magnum	20
> > > > warren	chrysler	avenger	40
> > > > troy	chrysler	avenger	20
> > > > detroit	gm	lacrosse	50
> > > > detroit	gm	impala	30
> > > > warren	ford	fusion	40
> > > > troy	chrysler	avenger	20
> > > > detroit	ford	taurus	10
> > > >
> > > > The formula I am having a problem with is:
> > > >
> > > > {=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}
> > > >
> > > > The Sumprduct yields 120 as the answer which is correct but the formula
> > > > above yields 355 as the answer.  What am I missing?
> > > >
> > > > Thanx in advance,
> > > > John
```
 0
Utf
11/18/2009 4:06:01 PM
```On Nov 18, 10:55=A0pm, Jacob Skaria
<JacobSka...@discussions.microsoft.com> wrote:
> What your formula does is
>
> =3Dsum(count number of 'taurus'+ count number of 'fusion' + the array D5:=
D18)
> =3Dsum(2+3+350)
> =3D355
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
> "JCS" wrote:
> > Thank you Jacob,
>
> > So, according to your solution, my solution is not possible.
>
> > John
>
> > "Jacob Skaria" wrote:
>
> > > 'array entered
> > > =3DSUM((ISNUMBER(SEARCH({"taurus","fusion"},\$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
>
> > > OR
> > > =3DSUMPRODUCT((ISNUMBER(SEARCH({"taurus","fusion"},
> > > \$C\$5:\$C\$18)))*\$D\$5:\$D\$18)
>
> > > If this post helps click Yes
> > > ---------------
> > > Jacob Skaria
>
> > > "JCS" wrote:
>
> > > > Hello Everyone,
>
> > > > I have been try to learn how to use the SUM function with multiple =
criteria.
> > > > =A0I have run into a road block with my experimentation. =A0By the =
way, I am
> > > > using Excel 2003 SP3. =A0My data looks like the following:
>
> > > > city =A0 =A0 Mfr =A0 =A0 model =A0 volume
> > > > dearborn ford =A0 =A0taurus =A010
> > > > troy =A0 =A0 ford =A0 =A0fusion =A020
> > > > shelby =A0 gm =A0 =A0 =A0lacrosse =A0 =A0 =A0 =A010
> > > > warren =A0 chrysler =A0 =A0 =A0 =A0sebring 10
> > > > dearborn gm =A0 =A0 =A0camaro =A030
> > > > detroit =A0ford =A0 =A0fusion =A040
> > > > shelby =A0 chrysler =A0 =A0 =A0 =A0magnum =A020
> > > > warren =A0 chrysler =A0 =A0 =A0 =A0avenger 40
> > > > troy =A0 =A0 chrysler =A0 =A0 =A0 =A0avenger 20
> > > > detroit =A0gm =A0 =A0 =A0lacrosse =A0 =A0 =A0 =A050
> > > > detroit =A0gm =A0 =A0 =A0impala =A030
> > > > warren =A0 ford =A0 =A0fusion =A040
> > > > troy =A0 =A0 chrysler =A0 =A0 =A0 =A0avenger 20
> > > > detroit =A0ford =A0 =A0taurus =A010
>
> > > > The formula I am having a problem with is:
>
> > > > {=3DSUM((\$C\$5:\$C\$18=3D"taurus")+(\$C\$5:\$C\$18=3D"fusion")+(\$D\$5:\$D\$18=
))}
>
> > > > The Sumprduct yields 120 as the answer which is correct but the for=
mula
> > > > above yields 355 as the answer. =A0What am I missing?
>
> > > > Thanx in advance,
> > > > John

Simple way is

=3DSUMIF(C5:C18,"taurus",D5:D18)+SUMIF(C5:C18,"fusion",D5:D18)

Worawat
```
 0
WKH8919
11/18/2009 4:22:13 PM
```Many thannks Don.  Your help is greatly appreciated.

John

"Don Guillett" wrote:

> =SUMPRODUCT((C5:C18={"taurus","fusion"})*D5:D18)
> Need NOT be array entered
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@austin.rr.com
> "JCS" <JCS@discussions.microsoft.com> wrote in message
> news:1884C168-4935-4CC3-AE9B-F103EDBF6354@microsoft.com...
> > Hello Everyone,
> >
> > I have been try to learn how to use the SUM function with multiple
> > criteria.
> > I have run into a road block with my experimentation.  By the way, I am
> > using Excel 2003 SP3.  My data looks like the following:
> >
> > city Mfr model volume
> > dearborn ford taurus 10
> > troy ford fusion 20
> > shelby gm lacrosse 10
> > warren chrysler sebring 10
> > dearborn gm camaro 30
> > detroit ford fusion 40
> > shelby chrysler magnum 20
> > warren chrysler avenger 40
> > troy chrysler avenger 20
> > detroit gm lacrosse 50
> > detroit gm impala 30
> > warren ford fusion 40
> > troy chrysler avenger 20
> > detroit ford taurus 10
> >
> > The formula I am having a problem with is:
> >
> > {=SUM((\$C\$5:\$C\$18="taurus")+(\$C\$5:\$C\$18="fusion")+(\$D\$5:\$D\$18))}
> >
> > The Sumprduct yields 120 as the answer which is correct but the formula
> > above yields 355 as the answer.  What am I missing?
> >
> > John
>
> .
>
```
 0
Utf
11/18/2009 4:29:03 PM

Similar Artilces:

multiple emails being sent out #2
It appears that when a message is sent through a > distribution list that sometimes the email gets hung in > the outbox. Outlook believes that the message has failed > to send but does not bring up an error message or > anything, it will just attempt to send it again approx. 2 > mins later. > The sending computer has in its sent items that the > message was sent at 10:30 AM > Two of the recieving computers recieved the message at > 10:14 AM > 10:18 AM > 10:20 AM > 10:22 AM > all computers recieve the time from the domain controller > so that the ti...

I am trying to find a way to Match on multiple values and return the header a row based on that. I have tried looking at combinations of vlookup, match, and index and so far haven't been able to figure out anything that can do what I need. I have a list of data with a person's name in the first column, and then headers for an action they took. Then data in each cell is then the date range they took the action. here is an example: Action 1 Action 2 Action 3 Action 4 John 2/3/2005 2/5/2006 5/7/2006 9/25/2006 Bob 1/3/2006 5/3/200...

Why does a graphic or print multiple times in the same document?
When I print from publisher to my Canon color copier,graphics appear multiple times in the same document. This could be many things- Temp files need cleaning A simple restart of cpu & printer A bad printer driver Check those first. "Carla" wrote: > When I print from publisher to my Canon color copier,graphics appear multiple > times in the same document. Carla wrote: || When I print from publisher to my Canon color copier,graphics appear || multiple times in the same document. Carla, check out the following kb article. This is actually a known bug that affects the e...

Calculated Control Refers to Multiple Reports
I have five reports, which for formatting reasons cannot be combined into one. They all open automatically with one command and need to be paginated as if they are one report. The number of pages for each report will differ depending on the data entered for each record. Pagination for each report sums the total number of pages ([Pages]) for the previous reports. The calculated control in the reports looks like this: report name: Report 2 control name: NewPage control source: =[Reports]![Report1]![Pages]+1 report name: Report 3 control name: NewPage control source: =[Reports]![Report1...

Easy formula question -sum of 1 cell to end
Thanks for looking . How do you format a formula to display the sum of, let's say A1 to "however far down the spreadsheet goes" without having to name an ending cell? This sheet has no end and I need to display the total in a column that keeps growing. I hope I phrased this correctly. Hi Edward You could do it this way =SUM(A:A), that will cover the full column. HTH John "Edward" <222@333.com> wrote in message news:erIdCRRkJHA.1288@TK2MSFTNGP02.phx.gbl... > Thanks for looking . > How do you format a formula to display the sum of, let's say ...

How do I auto sum on a form in publisher
I am trying to create a form that would auto sum columns like Excel. I can't figure it out! About the only way is to insert the Excel form as an Object. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Dawn" <Dawn@discussions.microsoft.com> wrote in message news:CD9B3D05-A0C5-4095-AB55-BC627D57DB50@microsoft.com... >I am trying to create a form that would auto sum columns like Excel. I can't > figure it out! ...

Problems with Exchange across multiple domains in same forest
Hey all, hoping I can get some help here: 1. Unable to view GAL for separate domain in same forest. Full GAL shows up in ESM but not in outlook. GAL that does show will update as new users added to first domain, but not second domain obviously. 2. Unable to authenticate to exchange server from second domain when setting up exchange connection. When setting up exchange connection using a user from first domain exchange works fine. Any help appreciated! -- ____________________________________________ Scott C. Reynolds - Tales From the SharpSide http://www.scottcreynolds....

multiple images in list control #2
Hi, I need to insert individual images for individual columns in a list control. How to go about this ? Thank you. ...

CRM REPORTS 01-18-07
Hi everyone. I've created reports using Reporting Services. I then imported these reports into CRM as part of a CRM development for a client. The client accesses our CRM website through the internet, using an ip address. They are then prompted for their credentials, which they then enter. They can successfully enter CRM, but cannot access our custom reports, however, they can access the standard CRM reports. I've successfully accessed CRM and the reports via the internet, using their credentials. Basically, I can access everything from my side, but they can only access CRM and ...

Changing formula in multiple cells or range simultaneously
I am trying to change the value in multiple cells in a large worksheet simultaneuously. I want to identify the range and then adjust the formula in the entire range. Is there a way that I can highlight the range and then change to formula in each, simultaneously? For example, if I wanted to double the value in the entire range, how would I do this? Thanks, Michael You could put 2 in an empty cell. Copy it Edit|Paste special|click on Multiply under the operation section. Then clear out that 2. But it really depends on what kind of change you're making. If you wanted to ad...

Criteria to return all records if selection from form is null
Hi, I'm trying to pass multiple query criteria from form controls. I'm using the following type of syntax for the criteria: Like Nz([Forms]![ViewEdit Completed Procedures]![SelectOBy],"*") And this works fine for the fields where there are no Nulls in the data, but if there are Nulls in this field I don't get those records. Quite understandable since Like "*" doesn't return Nulls. What I'm trying to do is to return all records when there is nothing chosen in the selection box on the form. I've tried a bunch of different IIfs wi...

Outlook Help #11
I am running outlook express 5 for mac. I would like to no how to put a graphic in with my signature. What kind of file and how to import it in. Thanks for any help!! PrePress <art@graphiccraft.com> wrote: > I am running outlook express 5 for mac. > I would like to no how to put a graphic in with my signature. > What kind of file and how to import it in. > Thanks for any help!! Ask in an Outlook Express newsgroup. -- Brian Tillman ...

Excel Array Formula: Multiple Criteria Sum IF Challenge
Currently, I have the following Excel Worksheet Invc No Code Status Charges RejCode 291 CH no pay 50 291 CH no pay 50 291 PY no pay ded 152 CH no pay 50 152 CH no pay 25 152 PY no pay dat 206 CH no pay 50 206 CH no pay 50 206 PY no pay 507 CH no pay 50 507 CH no pay 45 507 PY no pay ded 600 CH overpaid 25 600 CH overpaid 25 600 PY overpaid ded I would like to obtain the following results, Total Charges by Rejecte "no pay" invoices and the specific "no pay" invoices with rejections a displayed below: Total Charges by Rejected "No pay"...

Fein FBK-1 Filter Bag Kit for 9-11-55 Turbo I
List Price:\$48.20 Image: http://bestdeallocator.info/image.php?id=B001342J2E Best price found: http://bestdeallocator.info/index.php?id=B001342J2E This is a complete kit for converting the Turbo I vacuum to a two-stage filtration system. Remove the cloth dust bag and mount the 1 Micron filter and the dust bag to clean up smaller particulate material with the Turbo I vacuum. This kit includes everything necessary in one package. Great for work with drywall and sheet rock dust as well as other smaller particulate materials. SIMILAR PRODUCTS: Fein 913038K01 3-Pack of Vacuum Bags:htt...

Count with multiple criteria
Hello, I'm trying to find a way to make a small "load" calculator which would count the current load for each individual based on below data: A B C D JJ 4 21/04 JJ 2 19/04 BJ 2 18/04 DONE BJ 5 16/04 JJ 2 20/04 DONE BJ 3 24/04 Today : 21/04 A - Individual B - Hour required to complete task C - Deadline (week/year) D - "DONE" if completed, otherwise empty So the goal is to calculate for each indivual the total number of hours (from column B) with following conditions: for Individual JJ sum column B if C equal o...

formating multiple worksheet via print preview
I have a multiple worksheet workbook that I need to change several features about all the worksheets (page orientation, fit to 1 page, etc.). How can I do this formating and have it apply to all the worksheets selected in the group rather than having to do it to each worksheet separately? Thanks in advance. Roger Roger Group the worksheets you want to change. Change the relevant settings on one of them and it will be reflected in the others. Don't forget to ungroup the sheets afterwards. Andy. "Roger" <anonymous@discussions.microsoft.com> wrote in message news:0...

Subform Filter with Multiple Criteria
Hi all, I've got a subform and can filter via this code: frmSUB.Form.Filter = strFilter frmSUB.Form.FilterOn = True But, it only works with a single criteria, so when strFilter = something like [Application] = 'ProgramA' If I try multiple criteria, I get error 2448. Something must be wrong w/ my syntax, but I don't know what it could be. Anyone got any ideas? Thanks in advance - [Application] = 'ProgramA';[Profile] = 'AMAS' On Aug 3, 9:35 am, Zilty <ziltm...@yahoo.com> wrote: > Hi all, > > I've got a subform and can filter via this ...

percenatge increase in values across multiple cells
Hi I have a spreadsheet of numerical values and I simply want to increase all values, in all cells, by 17.5%. Can anyone please tell me how to do this? Many thanks David David Type 1.175 in a spare cell and copy it... Highlight your numbers and then edit>paste special...>values+multiply -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "David" <curvedball@yahoo.com> wrote in message news:9audnfgVAp7yfQfZRVnyrA@bt.com... > Hi > > I have a spreadsheet of numerical values and I simp...

Multiple windows
I have opened a workbook in multiple windows (to view side by side) but would now like to close the additional windows. How can I revert back to just one window? Select the window you don't want to see. hit ctrl-w to close it. Pete wrote: > > I have opened a workbook in multiple windows (to view side by side) but > would now like to close the additional windows. How can I revert back to > just one window? -- Dave Peterson ...

Sum Functions
I need to be able to add up all the data in two rows but only if the follow two conditions. I have tried to use a COUNTIF but it will onl allow one condition. Code ------------------- =COUNTIF(Database!I:I,"BD", AND(Database!K:K,"Yes") ------------------- the database isnt actually a database, rather a tab that I have one m spreadsheet. Has anyone any suggestions that could heklp me out?? need to say how many records are there with this row = BD and this ro = Yes. Thanks In advance -- andyb790 ---------------------------------------------------------------------...

SysDateTimePick32 CDateTimeCtrl DTN_FORMAT callback doesnt seem to work with multiple calls to SetFormat
It seems that the CDaqteTimeCtrl (aka SysDateTimePick32) does not work correctly if SetFormat is called more than once using a subclass of CDateTimeCtrl (e.g. class XDateTimeCtrl : public CDateTimeCtrl) with ON_NOTIFY_REFLECT(DTN_FORMAT, OnDtnFormat) and ON_NOTIFY_REFLECT(DTN_FORMATQUERY, OnDtnFormatQuery) with this sequence dt1.SetFormat("dd'/'MM'/'yyyy HH':'mmX") OnDtnFormatQuery pszFormat="X" setting szMax=(7,14) OnDtnFormatQuery pszFormat="X" setting szMax=(7,14) <<<<< not sure why the control sends 2 DTN_FORMAT...

multiple .rc files
Is it possible to maintain multiple .rc files in a project? If so, how do you edit them? compile them? How do you get them attached to your code? All this stuff was set up years ago by the wizard. I am maintaining one set of dialogs and my buddy is maintaing some others but they are both in the same .rc file and we have several times needed to add or change one of our dialogs and the other person has the .rc file checked out. Thanks, Ken You could copy the current resource file and split out the dialogs that are maintained by the other individual. Then rename that resource file with the ...

DLookup with mulitple criteria
I get a "Run-time error '2001': You canceled the previous operation" on the second line of my code. If I remove this line of code, everything works fine. I'm trying to locally retrieve all the ID numbers where the part numbers are the same to be displayed in a pop up message in this afterupdate event. Any ideas why I am getting this error message? Thanks! Private Sub Part_No_AfterUpdate() FirstID = DLookup("[ID]", "Part No for ID", "[Part No]= ' " & Me.[Part No] & " ' ") SecondID = DLookup(&...

Macro button
Lo Does anyone know how to add a macro button to the toolbar of ever user's copy of excel automatically? Can this be done with a registry file all users execute, then restar pc? Thanks, Carlo -- carl0s6 ----------------------------------------------------------------------- carl0s66's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1662 View this thread: http://www.excelforum.com/showthread.php?threadid=31490 Hi Carlos Create a Add-in with code that create the button and install this add-in on the users machine How to customize menus and menu bars in Ex...

Office 2003 and Windows 7 12-18-09
I've just bought a new laptop with Windows 7 64 bit and I loaded MS Office 2003 and added SP3. It seems to work OK but I have not yet explored the outer reaches etc. Dell Tech support tells me that Windows 7 will not run Office 2003, so I am on the look-out for problems but have not yet found any. What experience does the forum have? Happy Holidays. Mike My first reaction is that Microsoft is not that stupid, but I am a former employee and long time user of their products, so... Earle "MichaelRobert" <MichaelRobert@discussions.microsoft.com> wro...