View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robnarc Robnarc is offline
external usenet poster
 
Posts: 1
Default How can I SUMIF between rows rather than columns?

I need to sum the values in one row, but only if the corresponding values in
a second row fulfil a criteria.

e.g. With a budget laid out with a column for each month in 2010: for each
month sum "Cost A" if "Income type 1" 0.

Thanks!