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 multiple project types with variable pricing rates.

So basically I need some sort of "multiply if" equation. Any advice?

TIA!

Sheet 1:

Sheet 2:

excel

Lorenzo

Jun 09, 2024

Hi sdude1

With Table Pricing:

Total:

=IF(ISNUMBER([@Type]),
  SUM(
    FILTER(Pricing[[Service 1]:[Service 4]], Pricing[Type] = [@Type]) *
    Table1[@[Service 1]:[Service 4]]
  ),
  ""
)

sample_sdude1.xlsx14 KB

Lorenzo
Silver Contributor
Jun 09, 2024
Hi sdude1

With Table Pricing:

Total:
=IF(ISNUMBER([@Type]), SUM( FILTER(Pricing[[Service 1]:[Service 4]], Pricing[Type] = [@Type]) * Table1[@[Service 1]:[Service 4]] ), "" )

sample_sdude1.xlsx14 KB
- sdude1
  Copper Contributor
  Jun 09, 2024
  Thank you! This worked and taught me so much!
  - SergeiBaklan
    MVP
    Jun 09, 2024
    sdude1
    
    As variant
    
    =SUM( Table1[@[Service 1]:[Service 4]]* XLOOKUP([@Type],Pricing[Type],Pricing[[Service 1]:[Service 4]],0) )

Forum Discussion

Multiply cells based on another sheet

Share

Resources