I have this table :
There are 3 Sheets inside it.
The idea is to get how many ingredients used each day. For example as in Sheet1 in day 1 :
cake1 uses 2 chocolate cake2 uses 0 chocolate cake3 uses 0 chocolate cake4 uses 3 chocolate
So in day1, there are 5 chocolate used.
I use this formula in C3 :
Then i copy/paste to range C3:J7 and it works as i expected. Now, i want to make it as an arrayformula . So i modify it in Sheet2 :
=arrayformula( sumif($B$10:$B$28,$B3:$B7,C$10:C$28) )
it works for single column (in C3:C7 of the Sheet2 in link i share). I can then copy paste for other columns but i want to try to make arrayformula to works for the whole range C3:J7.
In Sheet3 , it populate the formula across the range C3:J7, but the value is wrong.
Can someone help if it's possible to make my arrayformula to apply to multiple columns ?