count and sum for the numbers

[mathanraj76]

Hi..

I have data in excel file .

i want to count the number and get the total for that particular numbers

for an example
count sum
- 2 to 25 10 23000
- 26 to 80
- 81 to 120
- 121 to 180
'
for 2 to 25 it must count number of records for "2 to 25" (">=2 to =<25")
let say it have 10 records then put number 10 in column count
then sum the 10 records and put into sum column

The data can go up to 150,000 ..

I have attached sample excel file ..

Thanks
Mathanraj

[AlKey]

You can enter this formula in B2 on Output for West sheet.

=COUNTIFS(Data!A2:A1527,">=2",Data!A2:A1527,"<=25")

[mathanraj76]

thanks

how to get sum
is that i need to use like this
=sumif(data!A2:A1527,">=2,Data!A2:A1527,"<=25")

how write this into macro so that when i click the button it will show result ..

Thanks
Mathanraj

[AlKey]

For SUM you can use this:

=SUMIFS(Data!$A$2:$A$1527,Data!$A$2:$A$1527,">=2",Data!$A$2:$A$1527,"<=25")

[mathanraj76]

can this formula write into vba code

I wan to know how to write these type of function into vba code in excel..

Thanks
Mathanraj