CountIf with dynamic content

#1

Hello.
I have a large bunch of data.
Lets say it looks like it:

Banana
Kiwi
Apple
Banana
Banana
Kiwi

I want to use this data to fill a table counting the occurence of every item.
In Excel, I would build a table like this :
Kiwi :
Apple :
Banana :
… :

And use a "CountIf formula to check how many “A1” there is (3 bananas), then how many “A2” there is (2 kiwis), etc.

I saw here a way to do the CountIf on Coda (Coda's equivalent to Excel's SUMIF, COUNTIF, and AVERAGEIF), but I don’t know how to do it the Excel way (like copy-pasting a formula to change it dynamicly).
In the example I saw I need to put manually the content (“kiwi”) in the formula instead of refering to another cell (“A1”) like in Excel and then copy-pasting it. So in my situation it would be very long to change manually the formula for all the options I have (let say I have a very long list of fruits).
=> What would be the correct “Coda way” of doing it?

Thx for your help in my switch :slight_smile:

#2

Hi @Jeremie_Abric - I have a feeling that @Joseph_B’s solution here - Filter created by to a summary table might be the solution here too. Take a look at it and let me know if it is not what you are looking for.

1 Like
#3

Thx.
It did help indeed, I figured out a way to get what I wanted :slight_smile: