Posted to microsoft.public.excel.worksheet.functions

Steen

external usenet poster

Posts: 104

SUMIFS

Normally SUMIFS uses an AND operator for the multiple criteria. How can I use
an OR operator. Example. I would like to calculate the sum of specific range
in case criteria 1 or criteria 2 is TRUE.

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 and SUMIFS	Colts41	Excel Worksheet Functions	0	August 27th 08 06:11 PM
SUMIFS and OR	mohavv	Excel Discussion (Misc queries)	4	January 30th 08 04:02 PM
SUMIFS	Mark	Excel Discussion (Misc queries)	3	November 28th 07 12:09 PM
SUMIFS and OR	M.S. Westerbeek	Excel Worksheet Functions	6	August 23rd 07 07:24 PM
SumIfs	timson	Excel Discussion (Misc queries)	3	January 26th 07 07:46 PM

All times are GMT +1. The time now is 01:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us