The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 countif in F(x)= as formula text

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: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
mhin Posted - 05/31/2022 : 06:58:15 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2022
Operating System: Windows

Hi,

is it possible to use a "countif" formula in the F(x)= cell and have the result display in the F(x) cell also? If I understood correctly, Formula Text should allow this, but I'm not getting it to work.

Specifically, I have a column with different values. I would like the number of cells in that column that have a value between X and Y to be outputted.

Thanks!
3   L A T E S T    R E P L I E S    (Newest First)
maudeunger Posted - 06/08/2022 : 04:42:01 AM
Thanks! I will work on it.

...
mhin Posted - 05/31/2022 : 09:59:35 AM
Hi James

yes, that's exactly what I'm after. It looks like it works when I insert a new user parameter and then enter the countif formula.

Thanks for your help!
YimingChen Posted - 05/31/2022 : 09:38:04 AM
Do you mean you want to display the countif result in the column header row? See the figure below as an example:


James

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000