Excel – nur jede zweite, dritte, vierte, n-te… Zelle summieren

Heute wurde ich in einer Schulung gefragt, wie man nur jede zweite, dritte, vierte oder n-te Zahl einer Matrix summieren kann.

Ich muss dafür folgende verschachtelte Formel eingeben und Strg-Shift-Enter drücken, um eine Arrayformel/Matrixformel zu erzeugen:

Man erkennt diese auch an den geschwungenen Klammern:

=SUMME(WENN(REST(ZEILE(A1:A30);4)=1;A1:A30))

Schreibe ich statt der oben rot markierten 4 eine andere Zahl, z.B. 2 oder 3, wird nur jede zweite bzw. dritte Zahl gezählt!

 image

Kommentare (23) -

Yaz lawyer
Yaz lawyer
18.11.2011 17:52:06 #

What a lovely blog site. I'll undoubtedly be back. Please preserve writing!

pelatihan hipnoterapi
pelatihan hipnoterapi
22.11.2011 16:31:10 #

I've been absent for a while, but now I remember why I used to love this blog. Thanks, I will try and check back more often. How frequently you update your web site?

Dunia Digital
Dunia Digital
22.11.2011 20:41:45 #

Hi there thank for give us valuable information in your blog i hope you can provide more information like this in future. Thanks friends.

Ferburgurz
Ferburgurz
29.11.2011 00:18:48 #

Breaking into this conversation to note that I recently went to a lecture by Mary Childers, who wrote "Welfare Brat" a few years ago. She's a true Horatio Alger stereotype: grew up on welfare with a mother who had eleven pregnancies by four different men, then started college at age 16 and eventually earned her Ph.D. I highly recommend her book. It's the only time I have ever waited in line to have an author autograph a book for me. By the way, she said she believes that today it is hardermuch harderfor a person to rise above poverty than it was in her day.|

500 rubles
500 rubles
16.12.2011 18:46:32 #

Thank you for your very great data and feedback from you. car dealers in san jose

kim holland tube
kim holland tube
24.12.2011 06:54:40 #

This is what movies do.

seo service for law firms
seo service for law firms
27.12.2011 09:43:25 #

Many thanks for today's post, seriously, can you sign up as a topic contributor for wikipedia because the current stuff submitted there for our hobby is quite frankly next to useless. I don't agree exactly with it but I agree with it on the most part and I wholeheartedly applaud your effort in putting it so ably.

I’d have to verify with you here. Which isn't something I usually do! I get pleasure from reading a put up that can make individuals think. Also, thanks for permitting me to comment!

Brice
Brice
27.01.2012 15:40:56 #

IMO fb contains the worst web site tempo of any in the important web-sites, what web site can you know of which is slower? I suggest occur on.

Beispiel-Name
Beispiel-Name
19.05.2012 20:02:04 #

Danke fürdie netten Infos

Notebook Reparatur
Notebook Reparatur
19.05.2012 20:03:07 #

Sehr gute Informationen danke an den Webmaster

fantasy football
fantasy football
03.06.2012 20:54:25 #

Hey There. I found your blog using msn. This is a really well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I’ll certainly return.

real instagram likes
real instagram likes
06.06.2012 22:52:43 #

certainly like your web site however you have to test the spelling on quite a few of your posts. A number of them are rife with spelling issues and I find it very troublesome to tell the truth nevertheless I¡¦ll surely come again again.

College Speaker
College Speaker
10.06.2012 21:27:16 #

Great work! This is the type of info that should be shared across the internet. Shame on the search engines for now not positioning this put up upper! Come on over and visit my website . Thank you =)

made in the usa
made in the usa
11.06.2012 17:32:51 #

Its like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a bit, but other than that, this is magnificent blog. A great read. I will certainly be back.

dmae side effects
dmae side effects
11.06.2012 18:50:00 #

I savour, lead to I discovered just what I used to be having a look for. You've ended my 4 day lengthy hunt! God Bless you man. Have a great day. Bye

billiga lån till bilen
billiga lån till bilen
12.06.2012 23:27:23 #

I have been checking out a few of your posts and it's nice stuff. I will surely bookmark your website.

kretaferie
kretaferie
13.06.2012 21:56:54 #

Generally I do not read article on blogs, but I would like to say that this write-up very pressured me to try and do so! Your writing style has been amazed me. Thank you, quite nice post.

trotinette freestyle
trotinette freestyle
14.06.2012 20:43:22 #

Thank you for every other informative website. Where else may just I get that kind of information written in such a perfect method? I have a undertaking that I am simply now operating on, and I have been on the glance out for such info.

007 Games
007 Games
15.06.2012 18:47:50 #

hey there and thank you for your info – I have certainly picked up anything new from right here. I did however expertise several technical issues using this website, since I experienced to reload the web site lots of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I'm complaining, but slow loading instances times will sometimes affect your placement in google and could damage your high quality score if ads and marketing with Adwords. Well I’m adding this RSS to my e-mail and can look out for much more of your respective exciting content. Ensure that you update this again soon..

Aaron
Aaron
15.06.2012 19:26:16 #

I do agree with all the ideas you have presented on your post. They are very convincing and will certainly work. Nonetheless, the posts are very quick for starters. May just you please extend them a little from subsequent time? Thanks for the post.

Miami Foreclosures
Miami Foreclosures
26.07.2012 02:40:54 #

If you want to see the mind blowing article with genuine details and figures, this has actually great impacts on readers and I admire the writing ability with the author.

Kommentar schreiben

  Country flag

biuquote
  • Kommentar
  • Live Vorschau
Loading

Facebook

Letzte Tweets

Twitter Mai 26, 23:39
Gelbe Engel! Danke!

Twitter Mai 18, 21:34
Finland was terrible. #Eurovision

Twitter Mai 17, 12:49
just blogged Ist das Surface Pro teuer? – Ein Fact-Check: Gestern wurde angekündigt, dass das Surface Pro in D... http://t.co/PhW7qzhkUq

Folge mir auf Twitter!

Über den Autor

MCTS

Christian Haberl Christian Haberl ist seit mehr als 10 Jahren als EDV Berater, Vortragender und Trainer tätig. Er kann sich nicht für ein Spezialgebiet entscheiden, drum heißt dieser Blog auch "Kraut & Rüben Blog" - Unter seine Interessen fallen Web-Entwicklung auf ASP.NET Basis, Information Worker & Productivity Technologien (Windows, Office), Server (Windows Server, Small Business, Virtualisierung, Exchange), Scripting, Spam Filtering/Security und Digital Home. Christian Haberl ist auch einer der führenden Produktspezialisten für Windows Media Center und Windows Home Server und ist Direktor des ClubDigitalHome.
Im Jahr 2008 hat Christian Haberl über 200 Vorträge und Schulungen durchgeführt.
Im Frühjahr 2009 wurde Christian Haberl von Microsoft Österreich zum "Influencer" ernannt, weiters wurde er Microsoft Certified Technology Specialist / Microsoft Certified Connected Home Integrator sowie Microsoft Certified Consumer Sales Specialist.

Month List

Netzwerk Management

Bandwidth

RecentComments

Comment RSS