Excel Forum • sumifs not worked with merged cells

Page 1 of 1

sumifs not worked with merged cells

Posted: Thu Jul 25, 2024 8:51 am

by sna

Hi there!
hope you're all fine

I need your help how use sumifs to work with merge cells without unmerge them

I attach a template

thanks

Re: sumifs not worked with merged cells

Posted: Thu Jul 25, 2024 9:20 am

by snasui

The example formula in F2 is,

=LET(x,SCAN(A2,A2:A7,LAMBDA(a,b,IF(b="",a,b))),MAP(E2:E3,LAMBDA(y,SUM(FILTER(C2:C7,x=y)))))

Enter

Re: sumifs not worked with merged cells

Posted: Thu Jul 25, 2024 10:04 am

by sna

wow,amazing !thanks so much