| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum(if not working
=SUM(IF(C2:C500="Bell",IF(F2:F500="Yes",1,0)))
I have a spreadsheet that housing a list of providers and a list survey questions. Columns F2 - F500 can be every "Yes" to "No". I tried to pick out all the "Yes" answers for this provider and keeps getting a "1". What am I doing wrong? -- Beverly C. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| amount of working days per month | Excel Discussion (Misc queries) | |||
| Calculation with Working day of the year | Excel Discussion (Misc queries) | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| Working time and days | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
Threaded Mode
