Sum function with a condition

**luizmachado** · 01-20-2016, 10:38 AM

Is there any way every time I submit data with userform (on this case, it would be "Categoria" column and "Total" column.) it keeps sum Total column values from a specify category ("Categoria" column).
For example: every time I submit data on "Casa" category, it would check every row with "Casa" and sum theirs values.
If we take this workbook print as an example, it would have to be =sum("J22","J25","J26","J27")and If I added one more row with "Casa", for example, it would be =sum("J22","J25","J26","J27","J28").

For "Casa" category values, the result from this sum would go to G27.

I guess I'd have to post all code here, but instead of it, I'm attaching the actual workbook here. Think it will be better for you.

This is my workbook:
c3013dc.png

**brokenbiscuits** · 01-20-2016, 11:16 AM

=SUMIF(Table1[Categoria],Table2[[#This Row],[Categoria]],Table1[Total])

**luizmachado** · 01-20-2016, 01:08 PM

This way it'll sum all "Categoria" column. I'd like that to sum all "Casa" category values from "Total" column. =(

**luizmachado** · 01-20-2016, 03:11 PM

I translated most of it to english, so I guess It will be easier to you guys see it.
Test.xlsm

**luizmachado** · 01-20-2016, 11:52 PM

Don't anyone know? I think that this =SUMIF(Table1[Categoria],Table2[[#This Row],[Categoria]],Table1[Total]) is a start, but I don't know how to rearrange it to work.

The code should check data every time it changes. As the example above, if I have J22/25/26/27 filled and on "Casa" category, it has to sum them all. And if some new data appears, for example, on J28 and it's from "Casa" category, it should "sum it to the code", like "=sum("J22","J25","J26","J27","J28") on "G27" ("Casa" total value).

My idea is that the table is always updated, even I someone makes a small mistake (like a wrong value) and wants to changes it on the table (instead of deleting all row to add it again by the userform).