•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula to mulitiply all values in one column based on the criteria of another.
Our take
If you're looking to multiply values in one column based on criteria from another, you can achieve this with a powerful formula that combines the `PRODUCT` and `FILTER` functions. This approach allows you to selectively multiply values from a specific column in your data set, depending on the conditions you set in another column. Similar to the `SUMIF` formula, this method enables you to focus on relevant data while simplifying complex calculations, empowering you to extract meaningful insights from your spreadsheets.
I'm looking for a formula that will mulitiply all values in one column based on the criteria of another. So on a data sheet; Column A contains text, Column B contrains a value.
Essentially I'm thinking like the SUMIF Formula, but instead of adding all the values, it multiplys all the values.
Thank you.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Is there a way to Sumifs up to a certain column with multiple criteria?Hi everyone, I’m looking for a formula to sum all of the columns starting from a particular column up to a particular column. How do I best do that? On the data tab, Row 1 I have the following columns: A1 = date B1 = serial number C1 = customer name D1 = date 1, with the data being $ E1 = date 2, with the data being $ F1 = date 3, with the data being $ In a separate tab I have the same thing mirroring the data tab, but without the $, for the calculation what I intend to do is on E2, I want to say if $A2 = E$ 1, then sum all of D up to E column on the data tab provided that the value on B column of the data tab match B2 of the calc tab, and C column of the data tab match C2 of the calc tab. For F2, it would be the same thing, but sum column D up to column F instead of column E. I hope it makes sense. Thanks for your help! submitted by /u/botng [link] [comments]
- Looking for a better way to do a multplication formulaGoing to attempt to word this where it is understandable. Right now I am having to manually type in the cell number into my formula for each area I would need it. For example =A35*2 written in cell A37 and having the *2 number two spaces above. Do I need to keep writing the cell numbers over and over in each space or is there an option to list *two cells above* multiplied by 2? Photo of what I am trying to accomplish. The values would obviously be different each use of this function. https://preview.redd.it/fnmp1dy6dj0h1.png?width=414&format=png&auto=webp&s=fdd86045c131652b9f2f79ec52bfcff8fdf7d690 submitted by /u/lilwigglyyak [link] [comments]
- How to sum all cells in column B where column A in the same row contains a specific string of text?I have a spreadsheet with names in column A and numerical responses in columns B, C, etc. I want to make it so that if, in a given row, column A contains a specific name (say, "Bob"), then the numerical value in column B in that same row will be added. Basically, I want the sum of all the rows in column b for which column a contains "Bob". I can't just sort by column a because sometimes it will contain multiple names per cell (ie Susan, Bob), and I need the equivalent numerical value to be added to both Bob and Susan's total. I've tried google searching this but I can't figure out how to specify same row but different column. I know I could probably do this with what I know already using just like... a lengthy chain of conditionals, but last time I tried that I ended up with an excel file that crashes my computer every time I try to open it, so I was hoping there's a better option. This is Version 16.85 on a Mac btw. submitted by /u/Odd_Nectarine6622 [link] [comments]
- Getting the sum of multiple row if an identifier is matched?So I have several sheets of data. Sheet1: Identifier https://preview.redd.it/7p7vv2lg4gyg1.png?width=128&format=png&auto=webp&s=7bce4e6ca02e9cb9ea5e3080ade52017af0a179d Sheet2: Find the identifier within the row. I have hundreds of rows of data. If an identifier is in the first 3 values, I want to add the first column after the break, 10. If the identifier is in the second set of 3 values, I want to add the column after that, 100. I want to add a column Sheet1 to contain the sum of that given identifier for my all my data rows. The data in the 6 columns will never have duplicates. https://preview.redd.it/vjdopflt4gyg1.png?width=1336&format=png&auto=webp&s=abf8ad27472f93a56dcd8864f42dcbea7cb6aa7a It would be something like this if I wanted to add a single row, but I want it to add all of my data rows. =IF(COUNTIF(Sheet1!B1:D1, A2) > 0, Sheet1!L1, 0) + IF(COUNTIF(Sheet1!E1:G1, A2) > 0, Sheet1!M1, 0) How do I find a single sum for a given identifier for multiple rows of data where I want to get the sum of a column if that identifier is in a different column? submitted by /u/Confused_Crossroad [link] [comments]