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:
#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.
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 ;
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... 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".
