LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WT WT is offline
external usenet poster
 
Posts: 16
Default Count and Sum function

I have a large range of data 37000 rows and multiple columns on a second
sheet that will vary in length more or less depending on the month.

I need to count the number of cells that contain the same value as in col A
but falls within a value between 0-50 in col b.

and then sum those same cells.

Obviously Sum and Count won't do this, please help.

Thanks in advance


--
Thank you
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Function Uma Nandan Excel Discussion (Misc queries) 2 September 24th 08 07:59 PM
COUNT(IF((,,,)) function vjmc Excel Worksheet Functions 5 June 19th 08 11:10 PM
COUNT IF FUNCTION nperpill Excel Worksheet Functions 2 January 10th 07 04:43 PM
Count Function Portuga Excel Discussion (Misc queries) 1 May 31st 06 04:53 PM
i need help with the "count" function kippercat Excel Worksheet Functions 1 March 9th 05 09:58 AM


All times are GMT +1. The time now is 04:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"