Is there a formula to count the number of cells in a selection that contain data?

If there is I could make the formula in Column BD a hell of a lot shorter.

 

 

 

The COUNTA formula returns the number of cells that contain any type of data in a range.

 

 

 

Ask more questions.

 

 

 

 

Jason Mraz :(

 

 

In for the Kill for number 1

The COUNTA formula returns the number of cells that contain any type of data in a range.

Ask more questions.

 

Thanks, I knew there was one, just couldn't remember its name :lol: :yahoo: That makes my spreadsheet overall much more simple

Here are the two songs that tied at #20 somehow.

 

=#20) BEYONCÉ – SWEET DREAMS [#5]

1,639 points // 23 weeks

52-13-9-6-5-5-5-7-9-13-17-22-25-27-33-35-42-43-48-57-64-72-75-x

The fourth single from I Am... Sasha Fierce. Making the top 20 as a fourth single is pretty impressive. Apparently samples Michael Jackson's Beat It, but maybe the backing music is just similar.

 

=#20) A.R. RAHMAN AND THE PUSSYCAT DOLLS FT. NICOLE SCHERZINGER – JAI HO! (YOU ARE MY DESTINY) [#3]

1,639 points // 25 weeks

20-5-3-3-4-6-7-9-11-15-17-20-24-27-42-62-70-67-31-41-56-70-81-97-x(4)-98-x

English lyrics on the Indian tune from the film Slumdog Millionaire. Nicole is a member of the Dolls, but credited separately for unknown reasons (though the group have now split up, maybe because of this).

Edited January 7, 201015 yr by BrayFish

My prediction:

 

1 "Poker Face" by Lady GaGa

2 "Just Dance" by Lady GaGa ft. Colby O'Donis

3 "Use Somebody" by Kings Of Leon

4 "In For The Kill" by La Roux

5 "I Gotta Feeling" by The Black Eyed Peas

6 "Sex On Fire" by Kings Of Leon

7 "Paparazzi" by Lady GaGa

8 "I'm Yours" by Jason Mraz

9 "Halo" by Beyoncé

10 "Single Ladies (Put A Ring On It)" by Beyoncé

11 "Boom Boom Pow" by The Black Eyed Peas

12 "Broken Strings" by James Morrison ft. Nelly Furtado

13 "Number 1" by Tinchy Stryder ft. N-Dubz

14 "Red" by Daniel Merriweather

15 "Beautiful" by Akon ft. Kardinal Offishall and Colby O'Donis

16 "Human" by The Killers

17 "I'm Not Alone" by Calvin Harris

18 "Not Fair" by Lily Allen

19 "Beat Again" by JLS

 

 

 

 

 

 

 

 

#19) CALVIN HARRIS – I’M NOT ALONE [#1]

1,666 points // 24 weeks

1-1-3-4-4-8-12-14-17-28-29-34-48-54-46-34-39-38-42-40-40-57-67-x(3)-98-x

First solo #1 for the Scottish singer and producer. My personal favourite #1 single of 2009 - epic! He scored 1,666 points, but this is not as much of a sign of the devil as Steve Angello and Laidback Luke ft. Robin S. - Show Me Love at #137, scoring 666 points.

The way Id do it, is to do the points system on all singles that reached their Peak position in 2009, however using their full chart runs even if that runs into 2010. Then you dont get the bias regarding release date.

#18) JLS – BEAT AGAIN [#1]

1,734 points // 24 weeks

1-1-2-4-7-12-13-17-23-26-33-38-36-28-31-35-41-33-41-47-55-60-57-49-

Début single from the boy band who finished 2nd in the 2008 series of The X Factor. Bad video, decent song.

The way Id do it, is to do the points system on all singles that reached their Peak position in 2009, however using their full chart runs even if that runs into 2010. Then you dont get the bias regarding release date.

 

Good idea, but it's hard to judge exactly when a song's chart run is over as it can always re-enter.

 

It would also discount songs that peaked in '09, then re-peaked in 2010 (Ke$ha - TiK ToK, probably Journey - DSB etc.)

Edited January 7, 201015 yr by BrayFish

Good idea, but it's hard to judge exactly when a song's chart run is over as it can always re-enter.

 

It would also discount songs that peaked in '09, then re-peaked in 2010 (Ke$ha - TiK ToK, probably Journey - DSB etc.)

 

 

well by the time the end of March comes you can decide which year they appear in and it wouldn't matter if they appeared in both.

#17) AKON FT. KARDINAL OFFISHALL AND COLBY O’DONIS – BEAUTIFUL [#8]

1,783 points // 33 weeks

66-59-53-52-56-54-56-30-13-9-8-8-9-12-15-23-24-29-26-33-36-39-47-52-70-99-97-71-61-74-87-x(1)-83-x(1)-99-x

A song that I initially hated, but it then grew on me. This making the top 20 means that Colby O'Donis has two entries in the top 20 despite having not yet charted with any solo material. The lowest of 7 songs in teh top 20 that first charted in 2008.

#16) LILY ALLEN – NOT FAIR [#5]

1,800 points // 26 weeks

16-12-11-10-9-9-8-5-7-9-13-17-24-33-42-43-43-28-34-42-51-58-53-70-80-99-x

Outpeaked and outsold by predecessor The Fear, but absolutely crushed The Fear on points and weeks. The video was a massive disappointment, but it's a pretty good song.

I have never heard Beautiful!

Good idea, but it's hard to judge exactly when a song's chart run is over as it can always re-enter.

 

It would also discount songs that peaked in '09, then re-peaked in 2010 (Ke$ha - TiK ToK, probably Journey - DSB etc.)

 

If the single leaves the chart during 2010, you stop counting even if it later re-enters.

 

#15) DANIEL MERRIWEATHER – RED [#5]

1,819 points // 26 weeks

5-5-5-5-7-8-17-17-18-19-19-22-29-24-26-34-39-50-50-45-35-54-62-67-73-72-x

Spent a month at #5. It went on to spend more time in the top ten than predecessor Change did in the top 100 (though Change did re-enter the top 100 for another 2 weeks around the time of Red's release). Its chart run was extended significantly due to constant use on the X Factor.

The video for Not Fair is incredible.

#14) THE KILLERS – HUMAN [#8]

1,948 points // 44 weeks

8-11-13-16-15-19-24-19-22-27-28-35-41-48-40-47-53-55-55-63-71-54-45-58-63-87-x(1)-88-61-69-73-77-73-69-70-78-88-100-x(1)-99-92-92-92-87-89-82-x

A 2008 song, but it managed to extend its run so far into 2009 that it completely overshadowed the other 3 singles from album Day & Age - "Spaceman" peaked at just #40, "The World We Live In" scraped in at #82 (12 places LOWER than the 2009 peak of ancient single Mr. Brightside) and "A Dustland Fairytale" missed the top 100 entirely. To be fair though, Human is musically superior to the followups, but Spaceman especially deserved a hell of a lot better than #40. You've gotta love the nonsensical lyrics in this one though ("are we human or are we dancer?", "my sign is vital, my hands are cold" etc.)!

To be fair though, Human is musically superior to the followups, but Spaceman especially deserved a hell of a lot better than #40. You've gotta love the nonsensical lyrics in this one though ("are we human or are we dancer?", "my sign is vital, my hands are cold" etc.)!

 

 

Spaceman is far more interesting than Human - which is just a bad PSB song.

#13) TINCHY STRYDER FT. N-DUBZ – NUMBER 1 [#1]

1,971 points // 33 weeks

1-1-1-2-3-4-8-11-13-17-30-34-25-26-28-32-38-37-42-47-59-61-66-65-65-76-83-82-80-70-66-94-95-x

Second single from Catch 22, and the first of 2 #1s. The only #1 song to ever have 'Number 1' in/as its title. Credits N-Dubz, but Tulisa and Fazer only appear in the video and don't sing at all. Dappy from N-Dubz does the chorus here.

#12) BEYONCÉ – SINGLE LADIES (PUT A RING ON IT) [#7]

2,064 points // 44 weeks

14-8-7-7-8-9-7-8-13-17-22-24-29-26-37-44-44-44-45-55-59-44-56-57-65-80-x(2)-90-90-84-80-75-78-84-77-91-83-93-91-97-x(3)-72-77-100-97-92-x

FOUL song, FOUL video. Originated as a B-Side and later became an official single, and, annoyingly, one with an extremely mega chart run. The video became a bit of a phenomenon for some reason, and was the subject of Kanye West's interruption of Taylor Swift at the 2009 MTV Video Music Awards. Achieved the rare feat of spending 3 weeks at a position that is not in the top 3 (#44 in this case)