Excel:Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded, that is, all those with “ON” regardless of the other term that accompanies them (as is the case with ON N1 or ON NM, for example) . CodeAssetTypeABCB4ABC BRASILPN N2EALT4ACO ALTONAPNAELP3AES ELPAONTIET3AES TIETE EON N2TIET4AES TIETE EPN N2TIET11AES TIETE EUNT N2BRGE8ALFA CONSORCPNDBRIV4ALFA INVESTPNALSC3ALIANSCEON NMALPA3ALPARGATASON N1

Use the following formula: =COUNTIF(range,"*txt*") =COUNTIF(C2:C11,"*ON*")

Answered: Excel: Create a totalizer (function or…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Excel:

Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded, that is, all those with “ON” regardless of the other term that accompanies them (as is the case with ON N1 or ON NM, for example) .

Code	Asset	Type
ABCB4	ABC BRASIL	PN N2
EALT4	ACO ALTONA	PN
AELP3	AES ELPA	ON
TIET3	AES TIETE E	ON N2
TIET4	AES TIETE E	PN N2
TIET11	AES TIETE E	UNT N2
BRGE8	ALFA CONSORC	PND
BRIV4	ALFA INVEST	PN
ALSC3	ALIANSCE	ON NM
ALPA3	ALPARGATAS	ON N1