Hi There,
Does anyone know what vba code I would use to perform a sort of SUMIFS() Formula in an excel userform, gathering relevant data from a spread sheet table? I have a userform with blank labels and a button. And I want the labels to display a total of specific items in my spread sheet table after pressing the button.
example of table:
a1 $300,000
b1 $100,000
a1 $150,000
a1 $311,000
c1 $400,000
and say I want the label in my userform to display the total of only the "a1"s and "b1"s. not the "c1"s. normally in excel I would use =sumifs(sumrange,criteriarange_a1, "a1", criteriarange_b1, "b1"). But what would I use to calculate this in the userform upon butt*******()?
Any help appreciated!
Does anyone know what vba code I would use to perform a sort of SUMIFS() Formula in an excel userform, gathering relevant data from a spread sheet table? I have a userform with blank labels and a button. And I want the labels to display a total of specific items in my spread sheet table after pressing the button.
example of table:
a1 $300,000
b1 $100,000
a1 $150,000
a1 $311,000
c1 $400,000
and say I want the label in my userform to display the total of only the "a1"s and "b1"s. not the "c1"s. normally in excel I would use =sumifs(sumrange,criteriarange_a1, "a1", criteriarange_b1, "b1"). But what would I use to calculate this in the userform upon butt*******()?
Any help appreciated!
