1 min readfrom 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!

https://preview.redd.it/7k81mb8q4ihg1.png?width=768&format=png&auto=webp&s=88edd01f781401b0303a5f5ebdf1a547c8605d6e

submitted by /u/CrazyMeansCreative
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

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