Hi,
Can anyone help me with a formula please....
I have the formula working already for similar data but when I change it to reference different data it doesn’t work so I am doing something wrong.
On the attached spreadsheet in the “Calcs” sheet is where I need the formula – highlighted in red.
The formula in green currently works which picks up data from the “receivables” tab based on the user selection of Branch, Date Range and Working capital element.
I need exactly the same but instead of summing the receivables sheet it sums the inventory sheet based on the user selections Branch (doesn’t change from above), Date Range (doesn’t change from above) but also inventory element (this is linked to cell C6 on the calcs sheet)
Please note that if the user selects the branch all it must sum all branches and if the user selects the inventory element all then it must sum
Can anyone see where I am going wrong?
Bookmarks