Conditional sumif returning zero

[saturdaygig]

Hi All

I have a long list of equipment to order. Each item fits into a procurement category (eg, bins or furniture) in column H and an installation group in column K (company that will purchase and install). Every item has a target install date in column J, and a number of items in column M.

I'm creating a table that will show number of items in each category/group combination that need to be installed each month, to inform the works programme, so:

bins - group 2 - number in month 1, number in month 2 etc

I put together a sumifs formula and as far as I can see it's correct, but it returns zero every time. This is the formula for just one cell in my table, although of course all formulae will be alike:

=SUMIFS('Full List'!M2:M863,'Full List'!H2:H863,"Furniture - Seating",'Full List'!K2:K863,"Group 3",'Full List'!J2:J863,"<=01/04/2020",'Full List'!J2:J863,">=30/04/2020")

This one is trying to pick up all group 3 furniture-seating which should be installed in April 2020. The formula returns zero, but should return 209.

Is there a syntax error here maybe? I've checked that all the cells are spelled exactly like the argument with no stay spaces.

 

[Fluff]

Swap the <= & >= signs around, you are currently looking for before April AND after April

 

[steve the fish]

Its impossible for a date to be before the 01/04/2020 and after the 30/04/2020 at the same time.

 

[saturdaygig]

Thanks both, exactly right.

Sometimes I'm just blind to errors however long I stare at them. Luckily we have Mr Excel to help with that.

 

[Fluff]

Glad we could help & thanks for the feedback