COUNTIF / COUNTIFS SUMIF / SUMIFS AVERAGEIF / AVERAGEIFS MEDIANIF / MEDIANIFS (ok, those aren’t in Excel but should be) etc…

Hey @Michael_Olenick , thanks for the suggestion! Coming from Excel I know these formulas are super easy and handy to use. In Coda, CountIf, SumIf, and AverageIf can only take integers as a predicate, no strings yet. This was a big concept for me to learn and the quick answer is to user filter with t…

Enhancement request - conditional aggregation functions

Product Feedback

Al_Chen_Coda June 1, 2018, 10:27pm 3

@Michael_Olenick Check out this article for my explanation of Excel’s SUMIF, COUNTIF, and AVERAGEIF formulas in Coda!

Topic		Replies	Views
Coda's equivalent to Excel's SUMIF, COUNTIF, and AVERAGEIF	8	6092	June 7, 2018
SUMIF() filtering a condition other than column to be summed? Product Feedback	11	11377	August 22, 2023
Can you do COUNTIFS formulas in Coda?	1	596	June 16, 2023
Need help filtering and sum(if)	1	429	May 16, 2021
Excel Countif function across multiple columns on a row in Coda	3	680	December 1, 2022

Enhancement request - conditional aggregation functions

Related topics