Comments Eric Hoober started the conversationAugust 14, 2017 at 3:27pmI uploaded the spreadsheet located in the above URL to wordpress, then went to link it to wpdatatables and it comes up with the following error:Sheet1!C2 -> Formula Error: Wrong number of arguments for COUNTIFS() function: 6 given, 2 expectedIf the formula works in Excel, why is datatables having issues? 1,846Miloš repliedAugust 14, 2017 at 4:14pmHi Eric,Thank you for your purchase.Sorry to disappoint you but unfortunately the formulas in the Excel files are not supported in our plugin features.You must clear all of the formulas ( or formatting ) in order to properly upload the file and create a table.Best regards.Kind Regards, Miloš Jovanović[email protected] Rate my supportTry our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/ wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community You can try wpDataTables add-ons before purchasing on these sandbox sites: Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables Sign in to reply ...
I uploaded the spreadsheet located in the above URL to wordpress, then went to link it to wpdatatables and it comes up with the following error:
Sheet1!C2 -> Formula Error: Wrong number of arguments for COUNTIFS() function: 6 given, 2 expected
If the formula works in Excel, why is datatables having issues?
Hi Eric,
Thank you for your purchase.
Sorry to disappoint you but unfortunately the formulas in the Excel files are not supported in our plugin features.
You must clear all of the formulas ( or formatting ) in order to properly upload the file and create a table.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables