Hi,
I want to sum a range that has both positive and negative numbers but would like to exclude either. I have tried =SUMIF(Sheet!X2:X2000,"AD",Sheet!D2:D2000, "<0") but it gave a calculation error.
Any help would be appreciated
Thanks
I want to sum a range that has both positive and negative numbers but would like to exclude either. I have tried =SUMIF(Sheet!X2:X2000,"AD",Sheet!D2:D2000, "<0") but it gave a calculation error.
Any help would be appreciated
Thanks