I currently have a formula that reads in a date range, start and end then in that date range add up the total cores then display for the date range, then against either silo's 1,2,3,4,5 totals the amount of cores for each.
M= cores
I = Start date
K= End date
L = Silo
X12= date start
X13 = date end
X14= Silo
Sum works fine, what I want to do now is adapt is so that I have another column called priorities, it has the value 1,2,3, I want it to sum the cores for the silo if it has priority 1,2,3 which is in column H. or I can call it in a cell aswell which is fine.
Any help appreciated deeply!
Bookmarks