Hello,

Looking for some guidance here. I'll try to explain it the best I can.

I have the following text starting in C1 and D1: Data Volume ***. The *** indicates there is other text in the cell but I want to use Data Volume as the base and possibly a wildcard for the rest of the text that's in the text. Basically, the two cells have Data Volume in common. The rest of the text is different.


List of B Volumes

A B C D E
? ? Data Volume **** Data Volume **** ?
? ? 1468 3265 ?
? ? 4564 56452 ?



The ? marks do not have any relevance. I just put them there as fillers. Here's the catch. When I paste data into the cell, the data under Data Volume could continue for several other rows. The problem is, I don't know how much further until I actually look for the data to paste. I want to be able to past the data and automatically SUM any numbers below Data volume in columns C and D. As in SUM until Blank? No clue how to do this. I can get it to SUM using the SUMIF(C1:D1, "Data *", C2:D3) but this is me manually inserting the formula because I know after I paste, how many rows of data I actually have to SUM.

Any help would be much appreciated.