LinkBack URL
About LinkBacks
hi,
I'm creating a table that has a categorisation of some sentences
These categories are in columns and the occurence is marked by an x.
I'd like to figure out how to count the number of Xs per category.
Any idea how I can do that?
Many thanks!
hi,
I'm creating a table that has a categorisation of some sentences
These categories are in columns and the occurence is marked by an x.
I'd like to figure out how to count the number of Xs per category.
Any idea how I can do that?
Many thanks!
I'd be inclined to use a helper row, hide it if necessary. e.g. in B12 copied to I12
=COUNTIF(B$15:B$30,"x")
Then in C3 copied down
=INDEX($B$12:$I$12,1,ROW()-2)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
IN C3 then copy down
=COUNTIF(INDEX($B$15:$I$30,,MATCH($B3,$B$14:$I$14,0)),"x")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
that worked like a charm! thank you so much!
Pl mark the thread solved.
Provide information regularly, the formula can be like this
C3 cell formula , drag down
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks