CarlyShannan
New Member
- Joined
- Apr 7, 2015
- Messages
- 7
Hi,
Trying to find a solution to make this spreadsheet work as easy as possible.
My sheet looks like this.
<tbody>
</tbody>
Sorry the table looks weird.
What I need is to look through all of column D for a certain text e.g. Showers3 then find the numbers corresponding in column I, then add them together.
E.G Showers3 is twice on this list D3 & D5 so the formula would add I3 & I5 together. $41119.47 + $62196.90 and in a cell it would show $103316.37.
Please no Macros if possible as I don't understand how to use it.
Thanks in Advance.
Carly
Trying to find a solution to make this spreadsheet work as easy as possible.
My sheet looks like this.
A | B | C | D | E | F | G | H | I | |||||||||||||
1 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||||
2 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||||
3 | 11646 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||||
4 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||||||||
5 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Sorry the table looks weird.
What I need is to look through all of column D for a certain text e.g. Showers3 then find the numbers corresponding in column I, then add them together.
E.G Showers3 is twice on this list D3 & D5 so the formula would add I3 & I5 together. $41119.47 + $62196.90 and in a cell it would show $103316.37.
Please no Macros if possible as I don't understand how to use it.
Thanks in Advance.
Carly