Thread: Nest SumIf
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] nybaseball22@gmail.com is offline
external usenet poster
 
Posts: 3
Default Nest SumIf

Hello. I am trying to use a formula that will sum a colum if the
criteria in one column equals a cell and the criteria in another
column equals another cell.

Example:

=SUMIF($A$11:$A$10000,$A$1,SUMIF($B$11:$B$10000,A3 ,$O$10000))

This funtion does not work, but it gives an idea of what I need to
do. Any idea how to make this happen?

Thanks