Posted to microsoft.public.excel.misc

external usenet poster

Posts: 11

Criteria Syntax in SUMIF formula

How do you use SUMIF, when your criteria is one of two(or multiple) values?

For Example, I want to use:

=SUMIF(A2:A10, ($C$1 or $D$1), B2:B10), but I know ($C$1 or $D$1) is not the
correct syntax.

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 Syntax	Rob	Excel Worksheet Functions	0	March 28th 07 01:56 AM
Sumif Syntax	Teethless mama	Excel Worksheet Functions	0	March 28th 07 01:22 AM
SUMIF Formula w/ OR Criteria	SJT	Excel Discussion (Misc queries)	5	August 4th 06 05:00 PM
Can a formula be used in the Criteria field of SUMIF??	peter	Excel Worksheet Functions	1	October 15th 05 12:14 PM
Multiple Criteria in a SUMIF formula	JCARROLL	Excel Discussion (Misc queries)	1	July 20th 05 09:17 PM

All times are GMT +1. The time now is 12:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us