csherman7992
New Member
- Joined
- Dec 14, 2016
- Messages
- 3
My data looks like this:
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>
I want to be able to sum all data in Row "X" that happens before Mar (based on header row). The row I want to sum is based on the criteria in the first two columns (ie sum the row that has "B" in column A and "BB" in column c).
How would I go about doing this?
Jan | Feb | Mar | Apr | ||
A | AA | 5 | 6 | 7 | 8 |
A | AB | 9 | 10 | 11 | 12 |
B | BA | 13 | 14 | 15 | 16 |
B | BB | 17 | 18 | 19 | 20 |
C | CA | 21 | 22 | 23 | 24 |
C | CB | 25 | 26 | 27 | 28 |
<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>
I want to be able to sum all data in Row "X" that happens before Mar (based on header row). The row I want to sum is based on the criteria in the first two columns (ie sum the row that has "B" in column A and "BB" in column c).
How would I go about doing this?