You could try this:
D12: =product(filter(E3:E5,B3:B5="APPS"))
D13: =product(filter(E3:E5,B3:B5="ROKU"))
Explanation:
filter(E3:E5,B3:B5="ROKU")creates an array with values for just "APPS" or just "ROKU"productmultiplies those values
Google Support
support.google.com › docs › thread › 180808528 › conditional-multiplication
Conditional multiplication - Google Docs Editors Community
September 24, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Google Support
support.google.com › docs › thread › 173312908 › multiplying-values-using-if-and-functions
multiplying values using IF < and >= functions - Google Docs Editors Community
July 31, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Help with Multiply if
In G3: =ArrayFormula(If(F3:F="Win",D3:D*E3:E-If(B3:B="Free",E3:E,0),"")) In I3: =ArrayFormula(If(H3:H<>"",SumIf(C3:F,H3:H,G3:G),"")) More on reddit.com
6
2
December 17, 2020How to automatically multiply a cell by 2
You would need Apps Script in order for entry, calculation, and output to all happen within the same cell. Apart from that, the simplest option would be to just have an adjacent column with a formula like =A1*2 that performs the calculation and output on the designated input cell. More on reddit.com
10
2
April 18, 2024How do I make an IF ">40"MULTIPLY formula?
Also to clarify I currently use a simple =MINUS(AH15,40) to calculate the hours of OT and then down towards the bottom where it calculates the dollar amount is a simple =MULTIPLY(AH15,31.5) BUT that results in a bunch of negative numbers if the OT is 0 or less which is fine as you can see i just changed the text color so its barely visible but i was hoping to avoid that with some sort of "IF then MULTIPLY" formula if its even possible. Thanks again for any help! More on reddit.com
4
1
July 30, 2022How to formulate conditional multiplications in Goggle sheets to calculate discounts based on volume.
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
8
1
April 1, 202403:01
How to Multiply in Google Sheets - YouTube
02:48
How to Multiply in Google Sheets [Updated 2026 Guide] - YouTube
07:02
How To Do Multiplication In Google Sheets - The 4 Best Ways! - YouTube
How to multiply in Google Sheets #googlesheetstips #googlesheets #googlesheetstutorial | TikTok
Better Analyst
betteranalyst.com › home › google sheets formulas › how to multiply in google sheets
How to Multiply in Google Sheets | Formulas
Multiply cells in Google Sheets with the asterisk operator, PRODUCT, and absolute references for fixed rates.
YouTube
youtube.com › watch
Google Sheets: How To Use the Multiply Formula - YouTube
Discover more tech tips at https://www.seniorplanet.org/videos.
Published: November 29, 2022
Reddit
reddit.com › r/googlesheets › help with multiply if
r/googlesheets on Reddit: Help with Multiply if
December 17, 2020 -
Hi,
I have some data I would like to multiply if certain criteria's meet.
Here is a spreadsheet with an example on it for you to look at.
What I would like,
If "Column 5" says "Win"
then
"Column 4" should be multiplied by "Column 3"
Also
All "Column 2" of the same text should be added together"
BUT
If "Column 1" says "Free"
Then
The amount of "Column 4" should be subtracted from the multiplication
So,
Row 1: 1.30 * £10.00 = £13.00
Row 2: 4.50 * £10.00 = £45.00 - £10.00 = £35.00
and so on.
If this is possible I would appreciate it, thank you all
Top answer 1 of 4
1
In G3: =ArrayFormula(If(F3:F="Win",D3:D*E3:E-If(B3:B="Free",E3:E,0),"")) In I3: =ArrayFormula(If(H3:H<>"",SumIf(C3:F,H3:H,G3:G),""))
2 of 4
1
Checkout the Tab "RAVV1325" The formula is in the GREEN Cell. Formula: =ARRAYFORMULA(TRANSPOSE({{TRANSPOSE(UNIQUE(FILTER(C3:C,LEN(C3:C))))};MMULT(SEQUENCE(1,ROWS(C3:C),1,0),N(IF(C3:C=TRANSPOSE(UNIQUE(FILTER(C3:C,LEN(C3:C)))),IF(F3:F="Win",(D3:D*E3:E)-(E3:E*(B3:B="Free")),),)))})) I hope thus helps.
TheGoodocs
thegoodocs.com › tips & tutorials › google sheets tutorials › how to multiply in google sheets?
Explore This Tutorial on How to Multiply in Google Sheets | Thegoodocs.com
November 8, 2023 - The multiplication formula in Google Sheets is the asterisk (*) symbol. For example, if you wanted to multiply the values in cells C4 and D4, you would enter the formula “=C4*D4” in a new cell.
Arab Psychology
scales.arabpsychology.com › home › how can i use a multiply if function in google sheets?
How Can I Use A MULTIPLY IF Function In Google Sheets?
June 27, 2024 - The MULTIPLY IF function in Google Sheets allows users to multiply values based on specific conditions. It combines the IF and MULTIPLY functions, enabling users to set conditions and perform multiplication calculations simultaneously.
LiveFlow
liveflow.com › product-guides › multiply-function-in-google-sheets
MULTIPLY Function in Google Sheets: Explained | LiveFlow
In Google Sheets, you can use the MULTIPLY formula to multiply two factors. Note that the MULTIPLY formula takes only two arguments and doesn’t accept a range or more than two factors as its arguments.
Softr
softr.io › home › blog › 100 google sheets formulas that actually work: a cheat sheet
How to use MULTIPLY in Google Sheets - Guide
July 23, 2026 - ROW (Lookup): Returns the row number of a given cell reference, or of the cell containing the formula itself if no reference is provided. IMPORTDATA (Web): Pulls data from a publicly accessible URL, such as a CSV or TSV file, directly into the sheet starting at the cell where the formula sits. MROUND (Math): Rounds a number to the nearest multiple of a factor you specify, rather than to a fixed number of decimal places like ROUND.
Ok Sheets
oksheets.com › multiply-values
4 Ways to Multiply Values in Google Sheets | Ok Sheets
The calculated field input in Google Sheets doesn’t have autofill or predictive text capabilities yet, so any misspelled word will either trigger an error or return the wrong result. You can create an Apps Script to carry out a multiplication operation.
YouTube
youtube.com › watch
How To Multiply Cells In Google Sheets - YouTube
Check out today's special tech deals:https://amzn.to/2WtiWdo*Use the above Amazon affiliate link to check out the latest deals on tech products. If you make ...
Published: May 13, 2022
Business Insider
businessinsider.com › business insider › how to multiply in google sheets in 3 ways, using a multiplication formula
How to multiply in Google Sheets in 3 ways, using a multiplication formula
August 23, 2022 - You can easily multiply in Google Sheets using formulas made up of of either numbers you choose, or cell data. Here's how.
Sheetgo
blog.sheetgo.com › home › how to use the sumproduct function in google sheets
How to use the SUMPRODUCT function in Google Sheets - Sheetgo
June 16, 2025 - The logic here may be confusing at first, but remember that in Google Sheets, True = 1 and False = 0. So when you use the SUMPRODUCT function with conditions that are True or False, you’re really just multiplying 1’s and 0’s. Of course, ...
YouTube
m.youtube.com › watch
Google Sheets | PRODUCT | Function | Multiply Numbers in ...
Share your videos with friends, family, and the world
Excel Champs
excelchamps.com › excel champs › google sheets
How to Multiply in Google Sheets
August 1, 2025 - Note – Make sure the date you are using is valid as per Google Sheets. The formula will not work correctly if sheets don’t understand your date. Let’s say you want to multiply two numbers in a single cell; in this case, you can use the below formula, which has two hard values within the cell using an asterisk (*).
Sourcetable
sourcetable.com › how-to-google-sheets › how-to-multiple-in-google-sheets
How To Multiply in Google Sheets
It can understand complex natural language requests, write sophisticated formulas, perform advanced analysis, generate insights, and work with data from multiple sources - all through conversational interaction rather than menu navigation. ... Yes, Sourcetable is fully compatible with Excel and Google Sheets.
Published: October 30, 2024
The Bricks
thebricks.com › home › resources › how to multiply in google sheets: a step-by-step guide
How to Multiply in Google Sheets: A Step-by-Step Guide
April 22, 2025 - One pro tip for using ARRAYFORMULA is to build in an IF statement to keep new rows from showing a "0" if there's no data. This modified formula will only perform the multiplication if there's an entry in the corresponding B column: ... This tells Google Sheets: "multiply columns B and C, but only do it for rows where column B isn't empty."
Layer
golayer.io › home › if statement in google sheets: formula & examples
IF Statement in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - In this guide, you will learn how to work with IF statements in Google Sheets. After reviewing the IF function syntax and some useful operators for your IF statements, you’ll learn how to use the IF function to test values using a logical expression and get a different value depending on whether or not it passes the test. You also have multiple examples with step-by-step instructions: how to combine IF and AND to check that multiple conditions are simultaneously TRUE, how to nest IF functions to test different conditions in order and return the corresponding value for the first condition found to be TRUE.
Owox
owox.com › blog › articles › google sheets tips › how to use google sheets if for conditional logic
Leverage IF Function in Google Sheets: A Complete 2025 Guide
May 14, 2026 - Using the IF function with AND, OR, or NOT in Google Sheets helps you handle more detailed logic. These operators let you test several conditions at once, making it easier to handle situations where your formula needs to follow more than one rule. It also helps determine if all or at least one condition is met, enhancing the flexibility and power of your IF statements in real-world scenarios. Combining the IF function with the AND function allows you to evaluate multiple conditions simultaneously.