sumifs multiple conditions stuck

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

Please Login or Register  to view this content.

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!

Maybe

Please Login or Register  to view this content.

it will add some and not the rest assuming that the <"&3 means priority 3

It might be easier for it to like where it reads input for silo in x14, read input for priority in x15

so I would input like:

1/1/2011 - START
17/12/2011 - End
Silo 1 - Silo
1 - Priority

tells me all cores which ***1*** priority

Sorry that should have been "<="&3, hence returning all priority values 1, 2, 3 and excluding any other priority value.

.....if it has priority 1,2,3 which is in column H .....

Can you post a sample workbook so that we can see your problem more clearly?

=SUMIFS(M:M,I:I,">="&J27,I:I,"<="&J28,K:K,"<="&J28,L:L,J29,H:H,J30)

I got this in, it will sum the majority of things on a certain silo with whatever priority they have, just not all of it?

I'm still not sure what you are trying to do, see if this workbook has what you need.

[EDIT 1]
Not sure why I didn't see your last post.
Your sample file is 2003 or earlier, but your formula using SUMIFS() will only work in 2007+

This suggestion was based on using 2003

[EDIT 2]
What is this meant to do?
=SUMIFS(M:M,I:I,">="&J27,I:I,"<="&J28,K:K,"<="&J28,L:L,J29,H:H,J30)
I can't see the logic in it, can you explain in words what you are trying to do?

See if this is better.

It could be simplified if you don't need it to work with pre 2007 versions of Excel

Okay.

I can see problems with putting your formula below your data table, why not put it in some spare column(s)?

Several of your dates are in fact strings that look like dates, these should be converted to serial dates if any formula is to give the correct result.

Try selecting each date column one at a time then use Text to Columns.

Delimited > Next > Next ... Select Date "DMY" from the dropdown > Finish.

By formatting these columns horizontal alignment > center you are masking this problem, although in this case you can still see some "dates" are out of line.
Best to never to align dates "center", then any errors are easily seen.