View Single Post
  #1   Report Post  
Scott Powell
 
Posts: n/a
Default SUMIF in multiple columns based on other criteria in Excel?

I'm trying to sum the number in one column based on criteria in another
column, but there are also multiple columns on the spreadsheet.

1 5 2 5 1.5 7 2 7


If the second number is a 5, I want the sum of the first numbers. Likewise
for the 7.

Thanks,
Scott