indiemusicboy
New Member
- Joined
- Apr 9, 2020
- Messages
- 47
- Office Version
- 365
- Platform
- MacOS
I have a workbook that contains (1) worksheet that will serve as a 'dashboard' or rollup of all other worksheet data in the workbook. The subsequent worksheets are form the same templates that will be reused (added) as net new worksheets in the workbook over time. So the dahsboard will stay the same, all other worksheets are from the same template but filled with different values.
In other words, Dashboard rollup, remaining worksheets are the same criteria about a customer people fill out per customer.
On the Dashboard worksheet, I want to sum up cell D121 on every worksheet in the workbook (not the dashboard) IF cell L3 equals a particular person's name.
I created a "FIRST" and "LAST" worksheet to give me buffers in the following formula but I keep getting Value or SLIP errors
=SUMIFS(First:Last!D121,L3,"Amanda")
D121 = a monetary value
L3 is a list of names where one is selected
"Amanda" is the name selected in this equation
So in the end if it searches all the worksheets and finds "Amanda" in L3, it will then report back a sum of cell D121 on those pages.
Can you help?
In other words, Dashboard rollup, remaining worksheets are the same criteria about a customer people fill out per customer.
On the Dashboard worksheet, I want to sum up cell D121 on every worksheet in the workbook (not the dashboard) IF cell L3 equals a particular person's name.
I created a "FIRST" and "LAST" worksheet to give me buffers in the following formula but I keep getting Value or SLIP errors
=SUMIFS(First:Last!D121,L3,"Amanda")
D121 = a monetary value
L3 is a list of names where one is selected
"Amanda" is the name selected in this equation
So in the end if it searches all the worksheets and finds "Amanda" in L3, it will then report back a sum of cell D121 on those pages.
Can you help?