Posted to microsoft.public.excel.worksheet.functions

kahuna

external usenet poster

Posts: 7

SUMIF WITH MULTIPLE CRITERIA?

Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!

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
sumif multiple criteria	Chris Cowles	Excel Worksheet Functions	9	May 26th 07 11:06 PM
sumif using multiple criteria	RMires	Excel Discussion (Misc queries)	3	September 14th 06 03:14 PM
Sumif with multiple criteria	jn77	Excel Worksheet Functions	5	July 19th 06 09:52 PM
SUMIF with multiple criteria	penri0_0	Excel Discussion (Misc queries)	5	May 18th 06 04:55 PM
SUMIF With Multiple Criteria	Mike	Excel Worksheet Functions	1	November 2nd 05 11:08 PM

All times are GMT +1. The time now is 12:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us