Office Software - [Pending] OpenOffice.org Calc posted in the Software forums; anyone can help me about openoffice calc
i would like to convert this excel formula =countif(sheet1!A2:A50;"*abc*") to openoffice calc formula
anyone can help? or any suggestions?
thanks! in advance...
Do you have the excel sheet with the data and formula that you want to transfer to Calc? If so, you should just be able to open the sheet in Calc, and it should do the work for you. I'll keep looking, for more info.
Let me know how you work out.
I am not sure if the Excel sheet that you have this formula on is working for you or not, but when I tested the formula I got an error on Criteria, "*abc*". This formula is pretty simple and should work with appropriate criteria listed. It is also simple enough that if your Calc cannot open it we should be able to walk you through recreating it.