Previous Topic Next Topic

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

Closed
jutulu Posts 34 Registration date Monday 10 March 2014 Status Member Last seen 21 September 2015 - 13 Mar 2014 à 04:05
jutulu Posts 34 Registration date Monday 10 March 2014 Status Member Last seen 21 September 2015 - 13 Mar 2014 à 14:44
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
Related:

1 response

Réponse 1 / 1
jutulu Posts 34 Registration date Monday 10 March 2014 Status Member Last seen 21 September 2015 2
13 Mar 2014 à 14:44
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?

Similar discussions

can't get time clock stopped off computer
chris -
Obwaya -

28 responses
Need for Speed crashes on desktop
recommendspc -
GINO -

20 responses