Alternative to CountIfs formula

[Karen_Larson]

Hi, I’m trying to find a way to work around the countif formula. I have two different transaction types. I’d like to create a formula that counts number of Transaction Type A records and another formula that sums the revenue from Transaction Type A records.If anyone has a workaround/solution I would very much appreciate the guidance.

[JonathanBowen]

Hi @Karen_Larson - how about this:

Make the types its own table and in the transactions table, link to the type:

Back in the Types table you can rollup and count the transactions by type:

JB