excel - Sum with dynamic condition -


i have excel file in columns. excel bank account.

the d column date, , not 1 day,its days of week. want columns in has same date, , insert in new cell.ex : week should have 7 sum.

here possible data sheet.

  date(column d)     money(column k)        sum of same date(column n)     1396/1/1                2300                   1396/1/1                1000                      3300 // of same date     1396/1/2                1200     1396/1/2                 320                      1550 // of same date 

it possible excel functions? need subroutin?

in l2 try,

=if(row()=match(d2, d:d), sumifs(k:k, d:d, d2), text(,)) 

fill down.

enter image description here


Comments