Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
I posted a thread awhile ago on two formulas in one cell and that worked great, but I've found that I like calling tabled data and am trying to do something a little different.
I have a table "tblItems" that has a ton of data in it. I have a formula that looks for a keyword and year to get me a total of that item in one year
Inside of B16 cell, where it says 17, like for it to actually say something like this based on another calculation:
17 (x Died)
Now, in the formula, under "In Place", there's a Yes No and Died. I've tried a few different variations but Excel keeps "Spilling" my formula and am not sure why.
I have a table "tblItems" that has a ton of data in it. I have a formula that looks for a keyword and year to get me a total of that item in one year
Data.xlsx | ||||
---|---|---|---|---|
A | B | |||
16 | Broilers Total | 17 | ||
OO Dash |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B16 | B16 | =+SUM(SUMIFS(tblItems[Amount],tblItems[Description], {"Broiler"}, tblItems[Date],">="&DATE(2021,1,1), tblItems[Date], "<="&DATE(2021,12,31), tblItems[In Place], {"Yes","No"})) |
Inside of B16 cell, where it says 17, like for it to actually say something like this based on another calculation:
17 (x Died)
Now, in the formula, under "In Place", there's a Yes No and Died. I've tried a few different variations but Excel keeps "Spilling" my formula and am not sure why.