Posted to microsoft.public.excel.worksheet.functions

zia

external usenet poster

Posts: 9

SUMIF multiple criteria

Hi,
I have two columns A and B. A column has Account # and B column has amounts
A B
10 100
11 200
10 300
13 400
14 500
11 600
Now I want to sum column B if value in column A is either equal to 10 OR 11?
so the formula in the above example should return 1200.
Thanks in advance

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
multiple SUMIF criteria	Markl9869	Excel Worksheet Functions	4	October 10th 08 03:20 PM
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria	kazoo	Excel Discussion (Misc queries)	2	August 21st 08 06:22 PM
SumIf with Multiple Criteria	DEE	Excel Worksheet Functions	4	November 21st 06 10:04 PM
SUMIF for Multiple Criteria	PCakes	Excel Worksheet Functions	2	October 20th 06 05:53 PM
SUMIF with multiple criteria	macquarl	Excel Discussion (Misc queries)	4	January 5th 06 02:18 AM

All times are GMT +1. The time now is 03:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us