Looking to SUM a columns data if two other columns meet a certain criteria.
IF
Column A = Norwich
&
Colum B = Used
Then
SUM Column C
Date
Votes
1 comment
-
Hi Tom,
Thanks for the post!
We support a SUMIF function that you can use in your formulas. For example, a formula like this will accomplish what you've outlined in your post:
SUMIF( AND( @A:A = "Norwich" , @B:B = "Used" ) , @C:C )
More information about this function can be found here
I hope this helps!
Parker
Please sign in to leave a comment.