OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] Counting values depending on value in another cell

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
cmclaren1978
Newbie
Newbie


Joined: 02 Jul 2012
Posts: 4

PostPosted: Mon Jul 02, 2012 12:41 am    Post subject: [SOLVED] Counting values depending on value in another cell Reply with quote

I was wondering if there is a way to do this?

Column A lists a row of cities, many of which appear numerous times
Column B lists a row of numbers from 0-10

I can work out how to count the number of 0,1,2,etc in Column B using the whole data, but how do I count the 0,1,2,etc in column B dependant on the city in column A?

For example, how can I work out how many 4s in column B are for Aberdeen in column A?

Thanks in anticipation Smile


Last edited by cmclaren1978 on Wed Jul 04, 2012 5:34 am; edited 1 time in total
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Mon Jul 02, 2012 2:18 am    Post subject: Reply with quote

Hallo

Code:
=SUMPRODUCT(A$1:A$1000="Aberdeen";B$1:B$1000=4)


The better choice for this kind of Tasks is →Data→Datapilot..

Karo
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group