thbutterflycollector_
New Member
- Joined
- Oct 29, 2015
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to sum the quantity of workers and the total duration of the shifts for an activity by activity and type of resource. However I keep getting the #SPILL error.
The source data is from a data dump a named range in a table
Essentially =SUMPRODUCT(Cost_Head="Staff")*(Sub_Head="Carpenters")*(Quantity,Duration)
The named ranges are on a different tab and I've checked that the number of rows reconciles which it does.
Any help appreicated.
I am trying to sum the quantity of workers and the total duration of the shifts for an activity by activity and type of resource. However I keep getting the #SPILL error.
The source data is from a data dump a named range in a table
Essentially =SUMPRODUCT(Cost_Head="Staff")*(Sub_Head="Carpenters")*(Quantity,Duration)
The named ranges are on a different tab and I've checked that the number of rows reconciles which it does.
Any help appreicated.