View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Sum If based on a 3rd condition ?

I have this formula that is totaling all the hours in the G colum if the data
in the C column matches the criteria entered in cell D2.

=SUMIF(Data!$C:$C,$D$2,Data!G:G)
I would like to obtain the above results filtered as follows.
The E column has many 1s, 2s, or 3s in it.
What formula would produce, - the total hours meeting the above criterea
but also only when there is a 1 in the E column ?

Thanks,

Steve