Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding up a column
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding up a column
=COUNTIF(A1:B20,"Y")*33
Adjust the range reference to suit. -- David Biddulph "Ronda" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
Adding minutes in second column to times in first column | Excel Worksheet Functions | |||
Adding one column based on results from another column | Excel Discussion (Misc queries) |