Quote:
Originally Posted by Wesler
Here's the function to get the negative numbers, which works. When I inverse the operator, it doesn't. Makes no sense I know, but such is Excel or my using of it.
=SUMIF((F13),(K13),(P13),(U13),(Z13),(F28),(K28),( P28),(U28),(Z28),(K43),...,(Z193))"<0")
|
The above is not the function as I have. I kept getting an error trying to put it in. Replace the commas with colons and it works for the negative numbers anyway. Also, I truncated the formula, but I think you can get the gist of ti from that.