Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
I have the following SUMIF statement but i would like to modify the formula
so it only counts the the negative numbers, i tried if<0 but no luck. =SUMIF(B2:B122,C123,D2:D122) the D reference should say somewhere 'if less than 0' - so it only counts negative numbers. thanks for your help. |