Thread: I am use (=IF(A2=1,"90") in a few cell i need to then add them up
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
 
Posts: n/a
Default I am use (=IF(A2=1,"90") in a few cell i need to then add them up
Is this what you're looking for:

=SUMPRODUCT((A2:A30=1)*90)
OR
=COUNTIF(A2:A30,1)*90

?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Jerome" wrote in message
...


Reply With QuoteReply With Quote