I am brand new here, so I apologize in advance for my lack of experience. I'm just learning VBA and macros and these forums have been such a huge help to me so far. I've tried searching through past posts, but I'm not quite sure how to phrase my question, so if the answer already exists, I apologize for the duplicate post.
I have the following text in C3:C8:
Show1: Group - Online
Show1: Group - Paid
Show1: Group - Unpaid
Show1: Member
Show1: Single
Show1: Subscriber
And the following amounts in E3:E8:
$43,197.00
$62,675.50
$-
$90,286.00
$200,123.50
$257,250.00
I also have a total line for each show, and on the total line, I want to sum the values in E, but only if the word "group" is contained in the text in the C cells. I have about 100 shows, and not all have the same number of rows. For example the next show might be:
Row C Values:
Show2: Group - Online
Show2: Group - Paid
Show2: Member
Row E Values
$-
$500.00
$5,000.00
So I want to sum at each total line based on the text for that show. How would I even begin to go about this? Please let me know what additional information I can provide or if I need to attempt to explain differently.
Thanks in advance for any help you can provide and I look forward to continuing to learn with the help of this forum!
Misty
Bookmarks