View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Adding up a column

Something like:

=COUNTIF(A:A,"Y")*33 + COUNTIF(C:C,"Y")*33

assuming columns A and C contain Y/N.

Hope this helps.

Pete

On Jan 20, 2:32*pm, Ronda wrote:
I have a couple of columns on my spreadsheet that have a "Y" or "N" answer. *
I need to add up the number of "Y"s and multiply it by 33. *What would be the
formula to this?