Forum Discussion

Kamilk95's avatar
Kamilk95
Copper Contributor
Jan 13, 2021

Excel SUMIF

I have a problem. I have a few columns with data, number and text, and above them i have cells with =Counta, which are counting not epty cells, and there are cells above them witch years date.  And i have cell witch actual year =Year(Today()), and i must calculate sum of results cells witch counta from this year and next years, and this must updating automatically every year. I tried =SUMIF(C1:G1;">=A1";C2:G2) but my results is 0, i tried =SUMIF(C1:G1;"YEAR(TODAY())";C2:G2) but this also does not work. When i try =SUMIF(C1:G1;">=2021";C2:G2) it works, but i must change date every year. How can I do this?

No RepliesBe the first to reply