viking flagship
New Member
- Joined
- Jan 28, 2007
- Messages
- 13
I am using the function:
=SUMIF(F5:F233,"Cars",H5:H233)
which is working fine.
However, H5:H233 are both positive and negative £ figures. I need to return 2 separate values in 2 different cells to show positive and negative totals separately.
This is probablly quite simple, but it's baffling me.
Any ideas anyone?
Thanks in advance
=SUMIF(F5:F233,"Cars",H5:H233)
which is working fine.
However, H5:H233 are both positive and negative £ figures. I need to return 2 separate values in 2 different cells to show positive and negative totals separately.
This is probablly quite simple, but it's baffling me.
Any ideas anyone?
Thanks in advance