First, Hello everybody and thank you for all the work and help you are giving on this forum.
In my company, we used to work with openoffice document but we upgraded and I have know access to excel only, which is pretty nice but it takes some time to adapt and learn how it works. anyway... I am stuck with a formula on calc:
=SI(NB.SI('1_Vocabulaire'!B3:D3,"A")>0,NB.SI('1_Vocabulaire'!B3:D3,"A"),SI(NBVAL('1_Vocabulaire'!B3:D3)>0,"X",""))
I have several pages on my document:
One page named "1_Vocabulaire" if in this page, in the cells B3, C3 and D3 there is a "A" I would like the cell to display the number of "A" in cells B3, C3 and D3.
If it is empty in B3 C3 and D3, no display.
If there is no "A", but some "X" display "0"
I would like this formula to be able to work on excel.
Thank you in advance for your huge Help
I am available for any questions or if you need any information.
PS: sorry for my English, I am French but I live in the US.
Matmax54
Bookmarks