Posted to microsoft.public.excel.worksheet.functions

Nan

external usenet poster

Posts: 23

SUMIF with multiple criteria

I'm trying to set up a criteria range using SUMIF.

ColA ColB
apples 1
carrots 2
apples 5
oranges 1
celery 2
apples 1
onions 2
apples 5
oranges 1
celery 2

I hoped something like =SUMIF(A1:A10,(OR("apples","oranges")),B1:B10) would
work, but the result is 0, not 14. Any help is appreciated.
--
TIA, Nan

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	Sarah (OGI)	Excel Worksheet Functions	5	September 26th 07 02:54 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 for multiple criteria	Inter	Excel Discussion (Misc queries)	3	May 17th 06 07:17 PM
SUMIF multiple criteria	HLS	Excel Discussion (Misc queries)	5	March 24th 06 03:43 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us