Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
I have a workbook with multiple worksheets. I'm creating a Dashboard that pulls from the other sheets. This dashboard needs to present the amount of grain purchased for 2020 (hard coded year).
This is what I have so far to calculate the type of grain in all years, but I need to filter just one year:
As you can see there, it's working but it's pulling totals from 2020 and 2021. Sum should be 3 and total should be $75.
BTW, XL2BB is excellent...
This is what I have so far to calculate the type of grain in all years, but I need to filter just one year:
Cell Formulas | ||
---|---|---|
Range | Formula | |
L19 | L19 | =SUMIF(Items!E2:E4995,"Grain - Broiler Crumbles",Items!I2:I4995)+SUMIF(Items!E2:E4995,"Grain - Starter Mash",Items!I2:I4995) |
M19 | M19 | =SUM(SUMIF(Items!E2:E5000,{"Grain - Broiler Crumbles","Grain - Starter Mash"},Items!J2:J5000)) |
As you can see there, it's working but it's pulling totals from 2020 and 2021. Sum should be 3 and total should be $75.
BTW, XL2BB is excellent...