Thread: SUMIF Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve M Steve M is offline
external usenet poster
 
Posts: 17
Default SUMIF Help

I want to sum the values in rows 2 to 100 in column G where the text in
columns D or E match the text in a given cell (say F3). I would like to be
able to change the text in cell F3 and still get the sum from G2 thru G100
where text in columns D or E match F3.