View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarod Jarod is offline
external usenet poster
 
Posts: 22
Default Sumif across multiple ranges

The formula is =sumif($C5:$C52,"H",D48:D52,D37:D42,D26:D31,D16:D2 0,D5:D10), I
had accidentally used L in the example above.