Previous Topic Next Topic

To start the sumif from partial text on first row of the day

Closed
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 13, 2014 at 04:05 AM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Mar 13, 2014 at 02:44 PM
Hi,

I have formula IF(COUNTIF(A$2:A1747,A1747)=1,SUMIF($A$2:$A$10000,$A1747,$G$2:$G10000),"")), which sums daily figures only for agencies by days. However, it goes to the top row and I need it to start on the first row that contains *DR* (I enter DR characters in brackets before the agencies name only to differentiate them). Anybody knows the hows? Much appreciated

1 reply

Answer 1 / 1
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 2
Mar 13, 2014 at 02:44 PM
On reading my own question I have realised that it is not very clear. Basically, what is required is the value to go not to the first row at the top of the beginning of the day, but on the first top row where the two characters *DR* appear, which is in column G (column A is the day, each day containing several rows). I have tried to use a wild card, but doesn't seem to like it. Any ideas?
0