| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM and IF statements
Column G, rows 2-83 have numbers ranging from -30 to +30.
Column I has a list of numbers I want to add when the values in Column G are greater than 9 or less than -9. I have tried this but do not get the correct result: =SUM(IF($G$2:$G$839,IF($G$2:$G$83<-9,I2:I83))) Can anyone help? Thanks, Bob |
Threaded Mode
