View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default 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!