Hello,
I'm normally okay at muddling though working out how to do what I want in Excel but I've had no luck trying to figure this out by myself using F1 Help or looking online. But at the same time I'm sure I'm thinking about it wrong and there is a simple answer I'm overlooking
So I'm starting off with something like this:
<table>
<tr><td></td><td>Apple</td><td>Banana</td><td>Clementine</td><td>Date</td><td></td></tr>
<tr><td></td><td>40</td><td>30</td><td>45</td><td>50</td><td></td></tr>
<tr><td></td></tr>
<tr><td>Anne</td><td>26</td><td>14</td><td>15</td><td>1</td><td></td></tr>
<tr><td>Betty</td><td>1</td><td>30</td><td>3</td><td>6</td><td></td></tr>
<tr><td>Cathy</td><td>29</td><td>28</td><td>8</td><td>46</td><td></td></tr>
<tr><td>Debbie</td><td>40</td><td>20</td><td>37</td><td>50</td><td></td></tr>
<tr><td>Etc.</td><td>2</td><td>30</td><td>45</td><td>50</td><td></td></tr>
</table>
The numbers under the fruit is the target or criteria for that fruit. I want to add a column to the end that counts how many fruits each person has hit the target for like so:
<table>
<tr><td></td><td>Apple</td><td>Banana</td><td>Clementine</td><td>Date</td><td></td></tr>
<tr><td></td><td>40</td><td>30</td><td>45</td><td>50</td><td></td></tr>
<tr><td></td></tr>
<tr><td>Anne</td><td>26</td><td>14</td><td>15</td><td>1</td><td>0</td></tr>
<tr><td>Betty</td><td>1</td><td>30</td><td>3</td><td>6</td><td>1</td></tr>
<tr><td>Cathy</td><td>29</td><td>28</td><td>8</td><td>46</td><td>4</td></tr>
<tr><td>Debbie</td><td>40</td><td>20</td><td>37</td><td>50</td><td>2</td></tr>
<tr><td>Etc.</td><td>2</td><td>30</td><td>45</td><td>50</td><td>3</td></tr>
</table>
But for the life of me I can't think how to go about it. I was thinking of using countif but I couldn't think how to make the evaluation for each cell to be relative to its position.
I'm stuck using Excel 2003 and your help is greatly appreciated, many a time I've ended up finding the answer on this site when I've needed help to get things done in Excel its been a godsend, thanks.
I'm normally okay at muddling though working out how to do what I want in Excel but I've had no luck trying to figure this out by myself using F1 Help or looking online. But at the same time I'm sure I'm thinking about it wrong and there is a simple answer I'm overlooking
So I'm starting off with something like this:
<table>
<tr><td></td><td>Apple</td><td>Banana</td><td>Clementine</td><td>Date</td><td></td></tr>
<tr><td></td><td>40</td><td>30</td><td>45</td><td>50</td><td></td></tr>
<tr><td></td></tr>
<tr><td>Anne</td><td>26</td><td>14</td><td>15</td><td>1</td><td></td></tr>
<tr><td>Betty</td><td>1</td><td>30</td><td>3</td><td>6</td><td></td></tr>
<tr><td>Cathy</td><td>29</td><td>28</td><td>8</td><td>46</td><td></td></tr>
<tr><td>Debbie</td><td>40</td><td>20</td><td>37</td><td>50</td><td></td></tr>
<tr><td>Etc.</td><td>2</td><td>30</td><td>45</td><td>50</td><td></td></tr>
</table>
The numbers under the fruit is the target or criteria for that fruit. I want to add a column to the end that counts how many fruits each person has hit the target for like so:
<table>
<tr><td></td><td>Apple</td><td>Banana</td><td>Clementine</td><td>Date</td><td></td></tr>
<tr><td></td><td>40</td><td>30</td><td>45</td><td>50</td><td></td></tr>
<tr><td></td></tr>
<tr><td>Anne</td><td>26</td><td>14</td><td>15</td><td>1</td><td>0</td></tr>
<tr><td>Betty</td><td>1</td><td>30</td><td>3</td><td>6</td><td>1</td></tr>
<tr><td>Cathy</td><td>29</td><td>28</td><td>8</td><td>46</td><td>4</td></tr>
<tr><td>Debbie</td><td>40</td><td>20</td><td>37</td><td>50</td><td>2</td></tr>
<tr><td>Etc.</td><td>2</td><td>30</td><td>45</td><td>50</td><td>3</td></tr>
</table>
But for the life of me I can't think how to go about it. I was thinking of using countif but I couldn't think how to make the evaluation for each cell to be relative to its position.
I'm stuck using Excel 2003 and your help is greatly appreciated, many a time I've ended up finding the answer on this site when I've needed help to get things done in Excel its been a godsend, thanks.
