Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 587

Nesting SumIf and CountIf

I want to count and sum data in one column based on on criteria from two
separate columns. I've tried AND and some othe ways, but can't get it right.

Essestially, (in english) count/sum the sales price if the sale type equals
a foreclosure and the unit type equals single family home.

Thanks in advance!

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 nesting ???	Dave	Excel Worksheet Functions	3	June 9th 08 05:18 PM
Nesting COUNTIF	Andrew K	Excel Discussion (Misc queries)	3	March 18th 08 02:17 PM
If and CountIF Nesting	nperpill	Excel Worksheet Functions	1	March 2nd 07 04:02 PM
Nesting SUMIF	360Kid	Excel Discussion (Misc queries)	3	June 1st 06 06:08 PM
nesting with countif	Ross	Excel Discussion (Misc queries)	1	September 14th 05 01:39 AM

All times are GMT +1. The time now is 09:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us