Try something like this, Andy:
=SUMIF(Sheet2!$A$1:$A$6,"<="&A2,Sheet2!$B$1:$B$6)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Andy787878" wrote
in message ...

The scenario is that i have 2 worksheets to link together.

In Worksheet 1 i have the following:
3 Columns, marked 1 (in B1), 2 (in C1), 3 (in D1)
5 rows marked 1-10 (in A2), 11-20 (in A3), 21-30 (in A4 etc), 31-40,
41-50


In Worksheet 2 i have the following data in 2 columns:
8 (in A1) 1 (in B1)
9 (in A2) 2 (in B2)
10 (in A3) 2 (in B3 etc)
21 3
7 1
44 1 etc
The question is, In sheet 1, can i get a formula to count the number
of (for example) 1's in the range of (for example) 1-10 by looking at
the data in sheet 2, and returning the number in Sheet 1 B2. In this
example, the number of 1's in the range 1-10 is 2.... But whats the
formula ??

I've been looking at Vlookup and Count functions and IF functions but
no joy yet, so if anyone can help please? Many thanks


--
Andy787878
------------------------------------------------------------------------
Andy787878's Profile:
http://www.excelforum.com/member.php...o&userid=15792
View this thread: http://www.excelforum.com/showthread...hreadid=382197