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

:-) Hi FatherRyan,

Welcome back to PCHF. I read through a previous post you had a bit back. Hope we were able to help you.

Have you tried to import the page you have the formula on? See if it is an option and I will do a little research on Calc.

I'll get back to you as soon as I can.

TTFN

T

:-) Hey FatherRyan,

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.

T

:-) Hi Once Again,

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.

I look forward to hearing from you.

TTFN

T