The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

How to write countif-formel?

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
elnino	Posted - 10/11/2016 : 08:50:59 AM Hello, I am trying to calculate with origin. I want that it Counts for col16 the first (and then go on)number of col15 if col2 is 12. I tried it to write as formel in differen ways. E.g.: if(col(C2)=12);Indexcount(col(C15));else type -b "0"; But it doesnt work. Or this one: if(col(C2)=12);countif(col(C15));else type -b "0"; It doesnt work again. I think I am writing the formel in a wrong way. Is there anyone who can help me? There also occures a error message: Mathematik kann nicht auf Textspalte angwandt werden/mathematics is not possible to apply in textcolumn
3 L A T E S T R E P L I E S (Newest First)
elnino	Posted - 10/12/2016 : 04:56:01 AM Hi, maybe i have to write something in the box below the formel box? could it be the Problem?
elnino	Posted - 10/12/2016 : 04:26:11 AM Hi Hideo Fujii! Thank you very much for helping me!! I tried to calculate with the formel you wrote. But then the same error message like before occured. Is the cell in the wrong Format or where is the Problem? I hope you can help me again!
Hideo Fujii	Posted - 10/11/2016 : 2:05:20 PM Hi elnino > if(col(C2)=12);countif(col(C15));else type -b "0"; You need the condition in the CountIf function as described in the document: http://www.originlab.com/doc/LabTalk/ref/Countif-func For example, you can use the function like in the sample below which counts for each cell in column B by searching the column A: The following script is equivalent to the use ofabove Set Column Values toollike: for(ii=1; ii<=3; ii++) { col(C)[ii]=COUNTIF(col(A),"col(A)==col(B)[ii]"); } Hope this helps. --Hideo Fujii OriginLab

The Origin Forum

Snitz Forums 2000