I have a form made based on the below
ID Customer Supplier Customer Name Customer Position Company Date Received Email Status Staff Name Int/Ext Telephone No Mobile No Text150 480
Customer
30-Nov-2017 Inactive External
481
Customer
30-Nov-2017 Inactive External
2340
Customer
Inactive External
3967
Customer
Inactive External
3 Customer
30-Nov-2017 Inactive External
2197 Customer
Active External
6079 Customer Jeon Asst Manager Daewoo 14-Jan-2018 Active External
Email status, Int/Ext and Customer Supplier are all dropdown.
I want to count how many is inactive, active, external, internal, customer and supplier (all different boxes)
my formula is as shown:
=count(iff([int/ext]="Active",1))
this shows a #ERROR
Where is the error on this when i followed almost the same formula and it works on their project.
any assistance and explanation is greatly appreciated.
Trident