| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement
Look at the following formula and tell me what is wrong with it. I am trying
to have a cell count "1" if a certain group of sponsors appear in the cell I have several sponsors in the same list. What I want to happen is when a certain sponsor is chosen I want it to count as 1 in another box. I have one group say in cells E2:E5 and another group in E6:E10. =IF(F4:F9=Lists!E13:E22, "1", IF(F4:F9=Lists!E2:E12, "0", IF(F4:F9=Lists!E23:E30, "0"))) This is the formula I came up with for one cell in my Totals area. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Threaded Mode
