Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Counting based upon 2 conditions that are text based | Excel Discussion (Misc queries) | |||
Counting cells based on formatting | Excel Worksheet Functions | |||
Counting based on other cells contents... | Excel Discussion (Misc queries) | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions |