methuselah
methuselah

Reputation: 13216

Count values in I if value in F = "In Progress"

I am trying to sum the row values in column I if the row value in F = "In Progress"

Sum appears to be stuck at 0... is there anything I'm doing wrong?

=SUMIFS(I:I,F:F,"==""In Progress")

Upvotes: 0

Views: 94

Answers (1)

jyek
jyek

Reputation: 1091

The formula should be =SUMIFS(I:I,F:F,"In Progress")

Upvotes: 3

Related Questions