Forum Discussion
Solved
Multiply cells based on another sheet
Hi everyone, I am trying to make Sheet 1 total each row based on the services provided. I will input the quantity of each service and I need it to multiply with the values on Sheet 2. I have multipl...
Hi sdude1
With Table Pricing:
Total:
=IF(ISNUMBER([@Type]),
SUM(
FILTER(Pricing[[Service 1]:[Service 4]], Pricing[Type] = [@Type]) *
Table1[@[Service 1]:[Service 4]]
),
""
)
Thank you! This worked and taught me so much!
As variant
=SUM( Table1[@[Service 1]:[Service 4]]* XLOOKUP([@Type],Pricing[Type],Pricing[[Service 1]:[Service 4]],0) )
