Glaswegian
05-19-2011, 06:27 AM
Hi
I need some formula help.
I have a row of figures that is broken into 2 sections
B2:H2 then K2:N2
Some figures in this row will be negative values and I want to sum only the negatives. I can work out how to do the first half using Sumif but I can't seem to include the K to N part.
I'd appreciate some help with this.
I need some formula help.
I have a row of figures that is broken into 2 sections
B2:H2 then K2:N2
Some figures in this row will be negative values and I want to sum only the negatives. I can work out how to do the first half using Sumif but I can't seem to include the K to N part.
I'd appreciate some help with this.