Sum up the product qty within specific time range?

[mmm1199]

As per title, can anyone teach me how to formulating the "SUMIFS" for different product qty in monthly basis?

I used below formula to obtain the monthly "In" & "Out" qty of each items, but it seems not working perfectly.
=SUMIFS('Daily Inventory Record-FE01'!$D$6:D66900,'Daily Inventory Record-FE01'!$C$6:C66900,"ADG8529(DR)",'Daily Inventory Record-FE01'!$B$6:B66900,{">=01/04/2018","<=30/04/2018"})

Pictures attached :-
->> Daily Inventory Record: to track daily movement of all products (act as a master list in my inventory database)
->> Monthly Inventory Report: to record monthly inventory movement for all the products, view monthly total in & out qty for each product.

To have better picture of what I've said, you may refer to the excel doc (my draft inventory database) by clicking below link.
->> https://www.dropbox.com/s/qt5x65sodjv9gor/Draft Inventory Report.xlsx?dl=0

Thank you!!!

 

[pgc01]

Hi

You have to separate the 2 date conditions, like

...,'Daily Inventory Record-FE01'!$B$6:B66900,">=01/04/2018",'Daily Inventory Record-FE01'!$B$6:B66900,"<=30/04/2018")

Remark:
I don't really like formulas that are region format dependent.

I would use instead
...,'Daily Inventory Record-FE01'!$B$6:B66900,">="&DATE(2018,4,1),'Daily Inventory Record-FE01'!$B$6:B66900,"<="&DATE(2018,4,30))

that would work anywhere in the world.

I'm assuming that B:B has date values.