Search code examples
excel-formulaformulasumifscalc

How do I find the sum of the values of a colum in Libreoffice Calc (or excel)?

I have date column H, and values in K, and I want to find the sum of the VALUES in K --if H is today.

I tried =COUNTIFS(K:K,"<>",H:H,">="&TODAY()) which gives me the number of entries today, but NOT the sum of their values!
Also, when searching I found some suggestions talking about greater/lesser than today, but I'm looking to compute Today only!

Solution

  • I prefer SUMPRODUCT for this.

    = SUMPRODUCT(K:K,(H:H=TODAY())+0)

    I recommend narrowing down the full column ranges to where ever your data actually ends (e.g. if you have 100 rows of data, change K:K to K1:K100).