Convert COUNTIFS to SUMIFS

0
votes

I currently have a formula which counts the number of rows that meet a particular condition in my spreadsheet.

=COUNTIFS(E:E,"<>",F:F,">="&TODAY())

As there are numbers within these rows, how do I count the value in them instead?

I've tried

=SUMIFS(E:E,"<>",F:F,">="&TODAY())

but Excel tells me I have not entered enough arguments, what am I missing?

2
excelexcel-formula
So far your formula specifies the criteria. Which cells would you like to sum? This is how SUMIFS works - Ioannis
@loannis - I am trying to sum the valuses in column E:E - methuselah

2 Answers

1
votes

This is what I used to add the values of the rows that have the date greater or equal to today's date: =SUMIFS(A2:A32,A2:A32,">="&TODAY())

And to count the days greater or equal to today's date you can use =COUNTIFS(A2:A32,">="&TODAY())

Is this what you are trying to do?

0
votes

To sum E:E based on the criteria in a countifs simply replace =countifs( with =sumifs(e:e,.

Sub sumifsCountifs()
    Dim fnd As Range, parm As Variant, tmp As String

    With Worksheets("sheet6")
        .Cells.Replace What:="=countifs(", Replacement:="=sumifs(e:e,", LookAt:=xlPart, _
                       SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False
    End With
End Sub