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.
Alternative to CountIfs formula
This topic has been closed for replies.
+18Hi @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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.