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:
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: Read More