Need help in Excel/Numbers

[ave]

I am currently busy re-organizing my collection file and as I'm a statistics freak, I want to see every detail at a glance.

There are two ideas I have but I don't know how to realize them.

#1
I want to count all of my magazines. Here's a screenshot of what it looks like:


I'd like to have the program count the amount of cells with content in a specified area. For instance, to calculate the number of magazines in the screenshot above, a command that calculates the number of cells w/content between C and N and 2 up to 25 would be exactly what I need.

#2

The second command I'm looking for is to distinguish the number of games per region. Beneath is an excerpt of my PS2 collection:


The command I need would need to count the amount of jp's, us's and pal's in a specified area, for instance "B2:B26".

Any help is appreciated! :thumbsup:

[Madroms]

#1
=NBVAL(C2:N25) in french => COUNTA in english, something else in german ?


#2
=NB.SI(B2:B26;"jp") in french => COUNTIF in english
replace "jp" with what you need to count

there is another formlua =bdnbval in french (DCOUNTA in english), more complex, that let you param more stuff.

[Jamtex]

in the first example if the numbers are indeed numbers then you just need

=COUNT(c2:n8) would count the number of ASM magazines you have

(if the aren't numbers then use

=COUNTIF(c2:n8,"<>""")


In the second example

=COUNTIF(b2:b26,"jp") would count the number of items with "Jp" in them

Openoffice is the same, just replace the , with a ;

[ave]

Thank you very much, that was exactly what I was looking for and it works like a charm :)
BTW, the German equivalent for COUNTIF or NB.SI is "ZÄHLENWENN" (1:1 translation of "count if").

Until now I thought I'd have close to 400 magazines but it turns out the collection has already grown to a massive 587. Oh dear... :rolleyes:
93 PAL, 44 US and 852 JP games keep them company. It's been about five years since I last counted my games by region and back then it was more like "350 pal, 50jp, 50us".