Thread: excel-count a value in 1 column if a value in a 2nd is true
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default excel-count a value in 1 column if a value in a 2nd is true
Hi,

You haven't given us much detail, so why not try COUNTIF(Range,Condition)

Note your subject line says you want to COUNT, your message says you want to
SUM??

SUMIF(Range,Condition,SumRange)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jim C." wrote:

I need to calculate the sum of a cable part number (included in column D3
thru D42) DEPENDENT ON the length of the cable in the adjacent (E) column
Reply With QuoteReply With Quote