•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Addition based on a selection in a list.
Our take
Are you grappling with how to perform an addition based on a selection from a list in your spreadsheet? You’re not alone—many users encounter challenges when trying to extract meaningful insights from their data. Fortunately, leveraging AI-native spreadsheet technology can simplify this process. With the right approach, you can dynamically calculate values based on your selections without the frustration of complex formulas. Keep reading to discover a straightforward method that will streamline your calculations and enhance your data management experience.
Hi,
I'm trying to make an addition based on the selection in a list.
So in my exemple, in the J collumn, G is 4 times so I3 should show 4.
I tried the SUMIF (SOMME.SI in french) formula but it doesn't seem to be working because I don't have another number to add to the formula.
The J collum is slected based on a list that I created in another tab and H3 use the same list.
Thanks in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#cloud-based spreadsheet applications#AI formula generation techniques#rows.com#Excel compatibility#Excel alternatives for data analysis#SUMIF#SOMME.SI#formula#addition#selection#list#J column#G#number#I3#H3#selected#exemple#create#tab