Assigning values to Excel cells

[4thinthetrilogy]

I'm trying to assign values to cells in an excel spreadsheet, so that if I enter say, an 'x', then this is counted as 1, in a total tally.

As a bit of background, I've got assets which I'm segmenting thematically by having each of the themes in a column. If the asset fits that segment, I want to mark it with an 'x' - each asset could fit multiple segments. Then I want to have a final column to calculate how many segments they fall in to.

Can anyone help with an approach on this?

 

[Ron Coderre]

Here are a couple options....

This formula counts non-blank cells
=COUNTA(A2:A100)

This formula counts cells containing "x"
=COUNTIF(A1:A100,"X")

Does that help?

 

[4thinthetrilogy]

Great! Thank you Ron.

If I wanted to take this model up a step, how could I assign more weight to particular segments?

E.g. Any cells marked with an 'x' in column A have a weight of 1. But any cells marked with an 'x' in column B have a weight of 5.

Would I be looking at a different approach?

 

[Ron Coderre]

Perhaps something like this:
=COUNTIF(A1:A100,"X")+COUNTIF(B1:B100,"X")*5

...or...this:
=SUMPRODUCT((A1:B100="X")*{1,5})

 

[4thinthetrilogy]

That works too. Thank you Ron, appreciate your time today.

 

[Ron Coderre]

Glad I could help.