Excel SUMIF

%3CLINGO-SUB%20id%3D%22lingo-sub-2057244%22%20slang%3D%22en-US%22%3EExcel%20SUMIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057244%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem.%20I%20have%20a%20few%20columns%20with%20data%2C%20number%20and%20text%2C%20and%20above%20them%20i%20have%20cells%20with%20%3DCounta%2C%20which%20are%20counting%20not%20epty%20cells%2C%20and%20%3CSPAN%3Ethere%20are%20cells%20above%20them%20witch%20years%20date.%3C%2FSPAN%3E%26nbsp%3B%20And%20i%20have%20cell%20witch%20actual%20year%20%3DYear(Today())%2C%20and%20i%20must%20calculate%20sum%20of%20results%20cells%20witch%20counta%20from%20this%20year%20and%20next%20years%2C%20and%20this%20must%20updating%20automatically%20every%20year.%20I%20tried%20%3DSUMIF(C1%3AG1%3B%22%26gt%3B%3DA1%22%3BC2%3AG2)%20but%20my%20results%20is%200%2C%20i%20tried%26nbsp%3B%3DSUMIF(C1%3AG1%3B%22YEAR(TODAY())%22%3BC2%3AG2)%20but%20this%20also%20does%20not%20work.%20When%20i%20try%26nbsp%3B%3DSUMIF(C1%3AG1%3B%22%26gt%3B%3D2021%22%3BC2%3AG2)%20it%20works%2C%20but%20i%20must%20change%20date%20every%20year.%20How%20can%20I%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

0 Replies