Hi guys!
Need some help regarding this matter. I have something like this data in a table:
<tbody>
</tbody>
What I need is to sum the numbers in column D that belongs to BP in column A, and only from the months associated to Expenses in column A. Please note that the months in column B are not formatted as DATE but as TEXT. Column C is not used.
Thanks!
Need some help regarding this matter. I have something like this data in a table:
Column A | Column B | Column C | Column D |
BP | January | Item A | 56756 |
BP | January | Item B | 4353 |
BP | February | Item A | 235 |
BP | February | Item B | 67457 |
BP | March | Item A | 4577 |
Expenses | January | Item A | 3452 |
Expenses | February | Item A | 345 |
Expenses | January | Item B | 577 |
Expenses | February | Item B | 4677 |
<tbody>
</tbody>
What I need is to sum the numbers in column D that belongs to BP in column A, and only from the months associated to Expenses in column A. Please note that the months in column B are not formatted as DATE but as TEXT. Column C is not used.
Thanks!