excelgoogle-sheetsgoogle-sheets-formulapercentagesumproduct
How to do SUMPRODUCT with percentage and blank cells
I am trying to do SUMPRODUCT in Google Sheets but in a more complicated situation.
I want to sum product with percentage instead of decimal number.
This is what I am doing now, and it works just fine:
A B C D
Price Tax Cashback
100 1.09 0.95
80 1 1
50 1.09 0.95
Total =SUMPRODUCT(B:B, C:C, D:D)
What I actually want to do is
A B C D
Price Tax Cashback
100 9% 5%
80
50 9% 5%
Total ???
Solution
Use
=SUMPRODUCT(B2:B, 1+C2:C, 1-D2:D)
- Recognize and process quotation mark (")
- Enumerate all data in Excel range, count them and sort by occurrence
- Add headers to table based on values found in cells
- Table Stacking using VBA
- how to handle excel files using C++?
- sqlite3 or CSV files
- Match and list values to a dynamic list including multiple column criteria
- Match and list values to a list including mutliple column criteria
- Transpose Excel data for multi-Stacked bar chart
- Match and list values based on values listed in another column
- Use pandas to read excel files with wrong sheet state
- Display x-rows below a certain position from a filtered and sorted list
- Get the first and last number occuring in a (text) string in a cell
- Count the program-steps
- Using VSTACK to pile-up results
- Excel vba Login to the site
- How to get a string array in an Excel cell and use as a reference
- Excel's max function returning wrong value when using vlookup
- Excel list of values where data matches across multiple rows
- How to save Image independently in VBA module
- How to map table references in a JSON file to corresponding values in an Excel file using Python?
- Move values from column to rows in Excel
- Application.FileDialog vs GetOpenFilename: What is the difference?
- Only display the values in a certain rank position from filtered and sorted list
- Convert table to reflect column names as row values
- Excel: Dynamic stacking or arrays n-number of times
- Convert Excel formula to Power Query (if countifs)
- Trying to hide rows in excel based on two values
- Combine every unique value from column A with duplicated values into a new sheet
- Import formula from variable - Excel VBA