Posted to microsoft.public.excel.misc

Baybora

external usenet poster

Posts: 3

How can I use OR function inside SUMIFS

I asked thsi question last week and thanks Luke M for his kind interest.

However it did not solve my problem
for example I'm writing
SUMIFS(long and 4-5 ciriterias).
But in one cirteria I need to say "OR"
A long way is I write
SUMIFS(...................................)+SUMIFS (.....................).
I cant imagine if my need will be 3-4 ORs : )
Best wishes,
Baybora

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
How can I use or funcition inside sumifs functiÄ±on ?	Baybora	Excel Discussion (Misc queries)	1	August 14th 09 03:13 PM
sumifs function	bcmlau	Excel Discussion (Misc queries)	3	August 4th 09 08:58 AM
Sumifs function	Alan	Excel Worksheet Functions	2	July 13th 09 07:16 PM
SUMIFS function help	teejay	Excel Discussion (Misc queries)	6	November 29th 08 08:13 AM
Can SUMIFS use the OR function?	Ted M H	Excel Worksheet Functions	7	January 2nd 08 11:18 PM

All times are GMT +1. The time now is 03:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us