SUMIF
Greetings all. I am trying to use sumif where the range and the sum range
are the same. I want to have one cell, say H1 that displays the sum of all values in the range H7:H10000 where the value is negative. This is what I have tried, but I get the error box saying there is something wrong with it. Is it not possible to have range and sum range the same? And if so how else could I do what I need to do? =SUMIF(H7:H10000, < 0, H7:H10000) |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com