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.

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]

Want to read more?

Check out the full article on the original site

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