Function SUMPRODUCT (or COUNTIFS) for 2 or more options?
I'm using Excel 2003 and for instance I have a following table:
1 2008 W
2 2008 W
3 2008 M
4 2009 M
I'd like to know how many 2008 year is in the column A which has
letter "W" for example. The correct answer is 2 and can get this with
The function COUNTIFS works only in 2007 :(
So that's okay. But now I'm changing the B column to following:
1 2008 W1
2 2008 W2
3 2008 M1
4 2009 M2
And now I'd like to know how many 2008 year is in the colum...Final solution to MAPI Error Message
JOHN HASKINS After experiencing the error generated message for all mapi
problems trying to use the send email functions in Office 2007, including
Word 2007, I now have solved the mystery. It was incredible all the postings
I have read, dating back to 2005 about this problem. To make a long story
short, follow this Microsoft link.
http://support.microsoft.com/default.aspx?scid=kb;EN=US;918792 If the typed
in link is not highlighted, just copy and paste to your browser. The main
Topics of this article [ Article ID: 918792 - Dec 15, 2009- revision 4 ] is
to 1. verify your...Supporting two executables in a solution
I use VS2008 and I need a solution that contains 2 executables (two
different processes) of which one should launch the other.
1. Does C# support such launching(with some paramters) an how?
2. Does VS2008 suport that-should I simply add the other excutables as I
would do with ordinary dll?
Thanks in advance
On 06.02.2010 16:06, Morris wrote:
> I use VS2008 and I need a solution that contains 2 executables (two
> different processes) of which one should launch the other.
> 1. Does C# support such launching(with some paramters) an how?
http://msdn...Which files and folders from the two solutions must be merged to combine web sites solutions
If I understand what I'm reading on the Internet the only way to combine two
website solutions and store them in one folder on a host is to make them
into one website solution. And there are certain files and folders in a
solution that have predetermined names and there can only be one of them.
And that means combining some files from two folders into one folder (like
the App_Code files) and combining some data from two files into one file
It would be great if I knew which files there can only be one of, as well as
which folders there can only be one of....talent management solution/Compenation Management Solution
My company is looking for a Talent Management Solution/Compensation
Management Solution. If anyone has any experience with any products, please
is there a way to set the solution to remain collapsed when it opens.
I have some solutions that have many projects. I've tried saving everything
everything collapsed. When I re-open it, everything is expanded. Manually
everything each time seems crazy. Is there a way to combat this?
thanks in advance,
Have you tried using the visual studio shortcut:
Collapse all tree nodes
NUM + -
Collapses all nodes in the current tree view.
Expand all tree nodes
NUM + *
Expands all nodes in the current tree view.
http://msdn.micro...How can I use a cell reference in Sumproduct array formula?
I have a table with dates down the and employee numbers across the top.
I have SUMPRODUCT formulas in all the cells to gather data from named
arrays from a database in the spreadsheet. I'd like to avoid munually
changing (either individually or with REPLACE) date and employee number
references in each formula in each cell. my formula looks like:
also, I used a previous suggestion from this forum on another similar
spreadsheet (successfully...for fiscal 3/05)with copying the whole
spreadsheet and changing the d...IE8 connection issues needs a more permanent solution
I was going to ask a question about connection problems with IE8 but it seems
a lot of other people have beaten me to it. Unlike most people, I am on
dialup so I thought it was having issues because of that although I did not
have the same problems with IE7. Now I see that connection type has nothing
to do with it. Like everyone else, I am experiencing intermitent problems.
Often reloading the page solves the problem. The diagnostics produces no
helpful results. And so on.
I have read the helpful advice being offered but I have a problem with that.
Seems it is up to us to make a...solutions
Get the solutions manuals you need at affordable cost.
Contact us at samedwards247(at)gmail(dot)com
Elementary Differential Equations Bound (2nd Ed.,Werner E. Kohler, Johnson)
Precalculus: Graphical, Numerical, Algebraic (7th Ed., Franklin Demana, Bert K. Waits, Gregory D. Foley & Daniel Kennedy)
University Physics with Modern Physics with Mastering PhysicS, 12/E, Hugh D. Young, Roger A. Freedman
Introduction to Electrodynamics (3rd Ed., David J. Griffiths)
Introduction to Quantum Mechanics (2nd Ed., David J. Griffiths)
Quantum Mechanics: An Accessible Introduction (Robert Scherrer)
Ele...Fun with SUMPRODUCT
Trying to solve for the following:
1) Priority = "Must"
2) Status <> "Closed", "Accepted", or "Testing"
3) Functional Area begins with "RPT"
4) Estimated Effort = "XL"
Wondering how best to modify the formula below to represent parts 2 and 3
above. How to represent contains "rpt" or begins with "rpt" (if wildcards
were permitted this would be too easy!) and accommodate the variable status
values we wish not to include.
I want to sum the total weight of a shipment.
I have weight per carton in (a), and nr of cartons in c.
In C1 I want a formula that would take the weight per cartop (per line)
multiply it by the nr of cartons (same line) and then add it all together.
I think I must use sumproduct.
Weights in A1:A20; number of cartons in B1:B20
Total weight =SUMPRODUCT(A1:A20, B1:B20)
Bernard V Liengme
remove caps from email
"Esrei" <Esrei@discussions.microsoft.com> wrote in message
&g...Where to adv/sell outlook solutions?
Does anyone know of a site I can usee to advertise or even sell my outlook
forms and solutions?
Thanks in advance...
Try http://www.slipstick.com -- send a message to the webmaster there.=20
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Tim Brocklehurst" <firstname.lastname@example.org> wrote in message =
> Does anyone know of a site I can usee to advertise or even sell my =
outlook=...Count if or SumProduct
I have two columns : column A defines the make/model; column B numerically
defines how many were sold . Note: There are multiple entries for the same
makes/models due to different territories.
I have a separate worksheet for which I need to summarize this info.
What would be the best formula for this task? I guess I am lost on what to
enter to count.
Any help is greatly appreciated!
Try this. The lookup value is in A1 of the currebt sheet
> I have two c...Looking for EDI solution
One of my clients needs to start accepting invoices from a major vendor
using the EDI 810 format. Does anyone have anything good (or cautions) to
say about any 3rd party EDI integrations out there?
Leslie Vail, CPA, MCT, MVP
MCBSP-Application for Microsoft Dynamics GP
MCBSP-Installation and Configuration for Microsoft Dynamics GP
We're implementing Vsync now (coming from eBridge, who did not suit us, but
have many customers). Things are progressing well.
"Leslie Vail [MVP]" wrote:
> Hi Fol...Is there a solution
Does anyone have a solution to this problem?
More information would be helpful, I don't believe most of us who read these
posting are very good at mind reading.
<email@example.com> wrote in message
> Does anyone have a solution to this problem?
-----BEGIN PGP SIGNED MESSAGE-----
On Fri, 22 Jun 2007, firstname.lastname@example.org wrote:
> Does anyone have a solution to this problem?
John Mayson <email@example.com>
Austin, Texas, USA
-----BEGIN PGP SIGNATURE--...No Buffer space available, any permanent solution ?
I have been experiencing this problem before but i can't find any permanent
I have tried searching for the solutions in the net but after reading all
threads , restarting is the only solution provided.
This problem occurs when my HQclient is attempting to connect. Thru VPN ,
Is their any other solution ? would increasing my ram will be a solution ?
hi Greg, I can understand how much worried you are with this problem, the
possible thing is that your connectivity to the HQ.
Editting the registry is not for beginners, if you don't kn...The solution
Hello. I'm not sure why, but when I click on the postings
telling me that a solution is just a click away, nothing
happens. I'm so close to balancing my checkbook, but so
far. Please, MVPs, can one of you re-post the
instructions so that maybe I can get the new posting
open? Or, even better, e-mail it? The e-mail is
firstname.lastname@example.org. Thanks a bunch!!!
Redmond, July 18, 2004, 22:00 PDT
I'm sorry that this post is so late, and I know that folks are frustrated
with the lack of communication. We have been on the verge of good news all
afternoon (and evening), and it...SUMPRODUCT between date range
I have successfully used SUMPRODUCT thanks to this discussion group but am
having a problem trying to capture a date range. Is it possibly the way I’m
entering the date? HELP! I woke up last night dreaming about this…
Date of Referral Homeless/At-Risk Received MV Services?
09/02/06 Homeless yes
09/15/06 Homeless yes
10/02/06 At-Risk yes
09/20/06 Homeless no
I need to capture the number of students fo...New Website Comparing POS Integration Solutions
We recently launched a new Website (http://
poswebstoreintegrations.com) that compares various POS Webstore
integration and eCommerce solutions. We hope that the site can provide
new insight into these solutions.
In our first post, we compared Nitrosell with Kosmos Central. Please
provide any feedback on our comparison. If you want to provide some
additional comparisons between the two, or with a new solution, please
feel free to do so.
POS Webstore Integrations Staff
On Jul 8, 4:29=A0pm, POS Webstore Integrations
> He...many reports solution
I have a web page to let user to define customized report. For now, just one
and two dimension reports.
And db has 11 entity tables, and a few tables to join them togeter. 11
entity joined in different path, in different way (1:m. m:m), directly and
Now the problem is the user want each dimension base on any entity.
Then I ned generate P(11,1) + P(11.2) = 11*1 + 11*10 = 121 combinations of
group by .
Multiple what to report (count(sth) , Sum(this), Sum(that)), I need
generate 363 reports.
The web page, in users eys, is so simple, just 3 dropdowns an...Solution: RequiredInfoState
Error message after 'successful' install: A required registry value is
Freshly built Windows 2000 PC with SP4 - no virus checkers of any
Error occurred when I installed to
D:\Program Files\Microsoft Money
it WORKED fine when I installed to
C:\Program Files\Microsoft Money
possible it has an issue with being installed to D:\Program Files
In microsoft.public.money, Steve wrote:
>Error message after 'successful' install: A required registry value is
>Freshly b...Microsoft Visio Partner Webcast
The practice of coordinating physical workspaces with the resources and
work of an organization is a major component of Facilities Management.
This can be a daunting task without the proper tool set. The August
15th Microsoft Visio webcast features two partners with Visio based
solutions that help to improve your ability to communicate your
Facilities Management designs, proposals, and ideas more effectively.
Join us on Tuesday, August 15th at 9am PST for an informative Visio
webcast on Facilities Management Solutions and experience one
partner's solution that brings the third dimension t...sumproduct in pivot
2003 version excel
In using a pivot table I would like to be able to customize using sumproduct
instead of sum or average, etc. Is there a way to do this?
wrote in news:808A66C1-A15D-41DB-B8E7-EAF03E00153F@microsoft.com:
> 2003 version excel
> In using a pivot table I would like to be able to customize using
> sumproduct instead of sum or average, etc. Is there a way to do
You have reached a newsgroup dedicated to Microsoft Access, the
relational database. Please hang up and try...EDI Solutions #2
Wanted to know which people had EDI and what solutions there were, not to
mention your experience with them. We are looking for a small EDI solution
to automate mostly just the 810 and 850 transactions in and out.
If you are interested we can offer a customized EDI solutions as per your
requirements. Please drop a emai to discuss.
Manager-Mid Market Solutions
> Wanted to know which people had EDI and what solutions there were, not to
> mention your experience with them. We are looking for a small EDI solution ...Do you have solution for me!!??
MAPI or unspacified service provider. ID no: c1050000 Exchange System Manager
Could you provide more information about when the error occurs.
This posting is provided "AS IS" with no warranties, and confers no rights.
"ToMMaS MooRe" <ToMMaS MooRe@discussions.microsoft.com> wrote in message
> MAPI or unspacified service provider. ID no: c1050000 Exchange System
check this out
Best regards, ...