Sum 2-dimension array

[hadoanpapvn]

Hi Everyone

I have the excel file to control storage as attached link.

The Sheet1 is an storage, and sheet2 contains goods which I want to take out....

I want to compare the quantity at Sheet2 with quantity at Sheet1 of item "Apple" with code is "AP" base on the current date&time and Expire Date.... If the Sheet2's "Apple" item quantity larger than Sheet1's "Apple" Total Product Quantity ( not expire date ) then the program will show alert "Not Enough"

Pls check my file & code and support me edit it.

Thanks you so much!

https://drive.google.com/file/d/1lS1COAUeCaJP8sO9HwApBwdrfapPW5C_/view?usp=sharing

 

[sheetspread]

=IF(E2>SUMIF(Sheet1!$B$2:$B$7,Sheet2!C2,Sheet1!$D$2:$D$7),"Not Enough","Enough")

 

[hadoanpapvn]

Hi Bro.

Thanks you but I want to use vba macro to do this

And the quantity must follow with expire date which compare with current date time

 

[sheetspread]

=SUMIFS(Sheet1!$D$2:$D$7,Sheet1!$B$2:$B$7,Sheet2!C2,Sheet1!$E$2:$E$7,">="&TODAY())

considers the expire date.

What do you want the macro to do? Put the formula in each cell or something else?