Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to add hours if 3 critera match.
In the below, if there is a 90 in the G column AND a 10 in the J Column, AND a 100 in the D column, then add the H column. Being that this criterea is found only in row 3 and row 6, I need the result to be 3 (H3 +H6). row D G H J 3 100 90 2 10 4 200 100 3 11 5 300 110 4 12 6 100 90 1 10 7 200 90 5 10 8 300 90 6 13 Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Too many 'if's! | Excel Discussion (Misc queries) | |||
Too Many If's | Excel Worksheet Functions | |||
IF's | Excel Worksheet Functions | |||
How many 'if's'? | Excel Discussion (Misc queries) | |||
to many 'IF's'?? | Excel Worksheet Functions |