Forum Discussion
Formula Correction
Hey Everyone, I am trying to apply one formula but it's giving me no results. Can anyone please correct this formula? Here is the formula =SUMIF(CONCATENATE("E:E",MATCH("ABC",A:A,0)),"T90",B4:...
Mojibure
Try using it with indirect function on your concatenated word.
=SUMIF(INDIRECT(CONCATENATE("E1:E",MATCH("ABC",A:A,0))),"T90",B1:B12)
Thank for the reply.
I have attached the snip for scanerio.
What I want is sum of column B on the basis of column C for each lebel of column A like for 123000, 87900 & 99800.
For info: here I have created only one pivot table but we have multiple pivot table like this below.
If you can frame any other formula that would be helpful or great if we can fix this one.
