Hi guys, im trying to sum the amount im the chart below but i believe the {} is wrong that it only reflects the 1st criteria. Cell C5
=sum(sumifs(I:I,H:H,{"*P77*","*M41P*","*GO57*"},G:G,B5))
Scratching head.. thank you guys!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 77px"><col width="77"><col width="100"><col width="100"><col width="100"><col width="20"><col width="52"><col width="149"><col width="78"></colgroup><tbody>
</tbody>
=sum(sumifs(I:I,H:H,{"*P77*","*M41P*","*GO57*"},G:G,B5))
Scratching head.. thank you guys!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
A | B | C | D | E | F | G | H | I |
2 | April Sales | 4/1/2018 | GO57 | 8,000.00 | ||||
3 | P77 | M41P | GO57 | 4/1/2018 | GO57 | 2,000.00 | ||
4 | 0 | 25720 | 10000 | 4/1/2018 | M41P | 20,000.00 | ||
5 | 4/1/2018 | 0 | 4/1/2018 | M41P | 5,700.00 | |||
6 | 4/2/2018 | 0 | 4/1/2018 | M41P | 20.00 |
<colgroup><col style="width: 77px"><col width="77"><col width="100"><col width="100"><col width="100"><col width="20"><col width="52"><col width="149"><col width="78"></colgroup><tbody>
</tbody>