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

[Closed]
Report
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
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

Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
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?