Posted to microsoft.public.excel.misc

lightbulb

external usenet poster

Posts: 61

SumIF with 2 Conditions

I'm needing to do a SUMIF function with two conditions, how do I do this?

For Example;

SUM the cells in AD7:AD294 when B4:B294 equal "F", AND when AD7:AD294 are
less than 200

Also, is there a way that if a column has dates and numbers in it you can
have a formula that disregards the dates and only sums the numbers rather
than treating the dates as numbers also?

Thanks!!

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 with 2 conditions	JBoyer	Excel Worksheet Functions	22	March 8th 10 08:04 PM
Can I have two conditions in a SUMIF?	trant	Excel Worksheet Functions	5	April 3rd 09 09:11 PM
SUMIF Two Conditions	mjones	Excel Worksheet Functions	0	October 8th 08 06:29 PM
sumif with 2 conditions ?? can this be done??	WTG	Excel Worksheet Functions	2	July 4th 05 10:08 PM
SUMIF with two conditions	Fred Holmes	Excel Discussion (Misc queries)	3	May 1st 05 10:10 PM

All times are GMT +1. The time now is 10:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us