LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Count values in different columns

I want a to calculate the number of values in row A for the corresponding
value in row C that is great than 1.
For example in row 4 in column A I have 0.0099 but 0 in column C in row 4,
therefore the result would be 0. For the whole column A the correct result
should be 3.
A B C
0.0134 10711
0.0160 8071
0.0170 16410
0.0099 0
0.0103 0
0.0085 8827
0.0135 0
0.0050 0.0164 0
0.0093 0
0.0105 16313



--
Chris
 
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
How to count with values from multiple columns? PF Excel Worksheet Functions 5 November 19th 09 01:57 AM
how do I count rows with text values in several columns. scmopar Excel Worksheet Functions 4 January 30th 09 02:20 AM
Formula to count values in two columns JBurlage Excel Discussion (Misc queries) 6 August 31st 06 12:59 PM
I would like to Count values in two columns. Roni Excel Worksheet Functions 6 June 5th 06 03:23 PM
How do I count values across multiple columns? [email protected] Excel Worksheet Functions 4 March 21st 06 11:13 PM


All times are GMT +1. The time now is 10:56 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"