On Excel is it possible to apply a certain formula after a new date is written on another cell?-CodePudding

I would like to apply this formula =SUMIFS(K:K;A:A;A3) on a cell on a column only after a change in the date for example:

On this image the 14/12 a sum is calculated 2 times while I would love it if only on sum would calculate for each day. Is this possible maybe add a check weather whats MAX day?

CodePudding user response：

Use =IF(COUNTIF(A$1:A3;A3)-COUNTIF(A:A;A3)=0;SUMIFS(K:K;A:A;A3);"") in the same row # as A3

The 1st countif is a counter from the first row up to the current row meeting the condition. The 2nd countif is a counter of total occurances of the condition. If 1st minus 2nd equals 0 it'll show your sumif formula, else it shows blank.