Firstly - THANKS everyone who replied :) I really appreciate the time you took to help me with my issue!
Quote:
Originally Posted by Spencer101
You can use the SUMPRODUCT formula below in any Excel version.
The COUNTIFS one will only work in Excel 2007 or later.
You just need to change the 5 & 10 in these formulas for appropriate numbers for each distance range.
You could put these in cells and reference them in the formula so you only have to write the formula once and then copy it. But without seeing your workbook I couldn't tell you exactly what the formula would look like then.
=SUMPRODUCT(('RED WET 1'!P4:P1855)*('RED WET 1'!P4:P185<=10))
=COUNTIFS('RED WET 1'!P4:P185,"5",'RED WET 1'!P4:P185,"<=10")
|
The SUMPRODUCT code here works perfectly and I've managed to cross-check the result in gathering up the sum of all the results and doing a quick few spot checks to see if they are adding up correctly. This is exactly what I was needing. Thank you!
I would have put up my spreadsheet but aside from the mileage aspect, a lot of it was confidential :) but thats perfect thank you.
Similar Threads
Threaded Mode
