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. |
If Statement
It's not real clear what you're trying to do...
Let's see if we can figure it out. when a certain sponsor is chosen I want it to count as 1 Ok, how is a sponsor chosen? A "certain sponsor" implies a *single* sponsor. If sponsor A is chosen, then you want to see if sponsor A is in the range Lists!E13:E22 and if it is return 1? What do these other ranges have to do with it? IF(F4:F9=Lists!E2:E12, "0", IF(F4:F9=Lists!E23:E30, "0" -- Biff Microsoft Excel MVP "Dave" wrote in message ... 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. |
All times are GMT +1. The time now is 08:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com