Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default counting text based cells

Hi, can you help me with formula for this:


XY A B C A B B A C 3

XX B C A B C A C B 2


I need to count "A" and sumarize it at end of row i.e. 3


Thank you
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 153
Default counting text based cells

XY A B C A B B A C 3
XX B C A B C A C B 2
I need to count "A" and sumarize it at end of row i.e. 3


Looks like a job for COUNTIF, maybe something like
=COUNTIF(A1:K1,"A")

Modify as needed.
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default counting text based cells

On Sunday, 1 March 2015 18:47:05 UTC+1, zvkmpw wrote:
XY A B C A B B A C 3
XX B C A B C A C B 2
I need to count "A" and sumarize it at end of row i.e. 3


Looks like a job for COUNTIF, maybe something like
=COUNTIF(A1:K1,"A")

Modify as needed.



Works, thank you very much.

Rgds
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting a mixed text/number column based on text in another colum Sierra Vista Steve Excel Discussion (Misc queries) 3 December 17th 06 06:30 PM
Counting based upon 2 conditions that are text based walkerdayle Excel Discussion (Misc queries) 7 August 22nd 06 01:29 AM
Counting cells based on formatting JRJ Excel Worksheet Functions 2 June 5th 06 11:26 PM
Counting based on other cells contents... George Excel Discussion (Misc queries) 3 November 8th 05 03:33 PM
Complicated counting of cells (based on other cells contents) George Excel Worksheet Functions 3 November 7th 05 07:39 PM


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"