Spreadsheet: 839990d1692348758-converting-a-sumifs-to-an-array-sample-worksheet
Sheet: Sample Worksheet

 | Transaction Table |  |  |  |  |  | Summary Table
 | Column B | Column C | Column D | Column E |  |  | Column H | Column I | Column J
 | Transactions | Date | Status | Amount |  |  | Date | # of X(s) | Credit Card |  | Formula for Column H |  | Formula for Column H
 | Transaction 1 | 2023-07-01 00:00:00 | xt | 64.99 |  |  | 2023-07-01 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H4) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H4)
 | Transaction 2 | 07/01/2023 | x | 75 |  |  | 2023-07-02 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H5) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H5)
 | Transaction 3 | 07/01/2023 | x | 68.34 |  |  | 2023-07-03 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H6) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H6)
 | Transaction 4 | 07/02/2023 | x | 20.07 |  |  | 2023-07-04 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H7) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H7)
 | Transaction 5 | 07/03/2023 | o | 64.9 |  |  | 2023-07-05 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H8) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H8)
 | Transaction 6 | 07/03/2023 | xp | 41.25 |  |  | 2023-07-06 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H9) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H9)
 | Transaction 7 | 07/03/2023 | x | 62.66 |  |  | 2023-07-07 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H10) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H10)
 | Transaction 8 | 07/05/2023 | x | 21.2 |  |  | 2023-07-08 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H11) |  | =[NAME])
 | Transaction 9 | 07/05/2023 | x | 14.95 |  |  | 2023-07-09 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H12) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H12)
 | Transaction 10 | 07/05/2023 | o | 122.24 |  |  | 2023-07-10 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H13) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H13)
 | Transaction 11 | 07/05/2023 | x | 14.95 |  |  | 2023-07-11 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H14) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H14)
 | Transaction 12 | 07/05/2023 | x | 71.16 |  |  | 2023-07-12 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H15) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H15)
 | Transaction 13 | [NAME] | xp | 28.2 |  |  | 2023-07-13 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H16) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H16)
 | Transaction 14 | 2023-07-09 00:00:00 | x | 60 |  |  | 2023-07-14 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H17) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H17)
 | Transaction 15 | 07/12/2023 | o | 117.75 |  |  | 2023-07-15 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H18) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H18)
 | Transaction 16 | 07/12/2023 | x | 13.85 |  |  | 2023-07-16 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H19) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H19)
 | Transaction 17 | 07/13/2023 | x | 55.12 |  |  | 2023-07-17 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H20) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H20)
 | Transaction 18 | 07/13/2023 | x | 23.97 |  |  | 2023-07-18 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H21) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H21)
 | Transaction 19 | 07/16/2023 | o | 263.46 |  |  | 2023-07-19 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H22) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H22)
 | Transaction 20 | 07/18/2023 | x | 68.29 |  |  | 2023-07-20 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H23) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H23)
 | Transaction 21 | 07/18/2023 | x | 6.5 |  |  | 2023-07-21 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H24) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H24)
 | Transaction 22 | 07/18/2023 | x | 18.69 |  |  | 2023-07-22 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H25) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H25)
 | Transaction 23 | 07/19/2023 | x | 62.6 |  |  | 2023-07-23 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H26) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H26)
 | Transaction 24 | 07/19/2023 | x | 87.06 |  |  | 2023-07-24 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H27) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H27)
 | Transaction 25 | 07/20/2023 | x | 0.94 |  |  | 2023-07-25 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H28) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H28)
 | Transaction 26 | 07/25/2023 | x | 43.38 |  |  | 2023-07-26 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H29) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H29)
 |  |  |  |  |  |  | 2023-07-27 00:00:00 |  |  |  | =[NAME]) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H30)
 |  |  |  |  |  |  | 2023-07-28 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H31) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H31)
 |  |  |  |  |  |  | 2023-07-29 00:00:00 |  |  |  | =[NAME]) |  | [NAME])
 |  |  |  |  |  |  | 2023-07-30 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H33) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H33)
 |  |  |  |  |  |  | 2023-07-31 00:00:00 |  |  |  | =COUNTIFS($D$4:$D$34,"=x*",$C$4:$C$34,$H34) |  | =SUMIFS($E$4:$E$34,$D$4:$D$34,"=x*",$C$4:$C$34,$H34)
 |  |  |  |  |  |  | Total