Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum based on specific condition | Excel Worksheet Functions | |||
Sum calculation based on condition | Excel Worksheet Functions | |||
Copy Row based on a condition | Excel Worksheet Functions | |||
help me getting value of column based on condition | Excel Worksheet Functions | |||
Cannot sum values based on condition | Excel Worksheet Functions |