Menu

Excel Sum with multiple (over 2 criteria)

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Don Guillett

Posts: n/a

Default

Excel Sum with multiple (over 2 criteria)

glad to help

--
Don Guillett
SalesAid Software

"Joe D" wrote in message
...
I have it, works great. Thanks much.
Joe
--
Joe D

"Don Guillett" wrote:

Without seeing your setup I would recommend sumproduct. Be aware that
the
ranges must be the same size. An example
=sumproduct((a2:a22=1)*(b2:b22="Joe")*c2:c22)

--
Don Guillett
SalesAid Software

"Joe D" wrote in message
...
I've been trying to get this to work for several hours and am at my
wits
ends. I have a data table with one column of numberical data that i
need
to
sum based upon three or more critria contained in other columns. The
data
represents investments and their market values.

I have named each of the columns with a range name. THe critria as
described by their range names and examples of each are :

Country - USA, Great Britain, Japan, etc.
Currency - USD, EUR, GBP, JPY
Type - Bond, Loan, Equity
long_short - Long, Short

I will do many different formulas once I have one that works. I was
able
to
get a formula to work with two criteria. I would like a formula that
adds
the market values of all securities that are Type-Long, Currency-USD,
and
Country-USA.

Any help would be appreciated.

--
Joe D

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can i open multiple excel sheets separately	srinu	Excel Discussion (Misc queries)	1	July 8th 05 04:38 PM
Sort rows across multiple worksheets - Excel 2003	Stamdale	Excel Worksheet Functions	2	July 5th 05 04:30 PM
Exporting from Excel to multiple XML files	Questions	Excel Discussion (Misc queries)	0	March 17th 05 10:20 PM
how do I search by more than one criteria in excel?	vulcan88	Excel Worksheet Functions	2	March 15th 05 09:18 PM
How do I ask for multiple criteria when creating a "sumif" formul.	Rachelle	Excel Worksheet Functions	3	December 1st 04 11:49 PM

All times are GMT +1. The time now is 05:49 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement