this made my day, helping my friend. thanks
nice video
Excellent
Useful but only applicable where criteria is unique. If Jan is occuring twice, in the abstract sheet it will show value only with the corresponding row number. SumIfs with Indirect I think can be a better alternative.
Thanks Teknisha, you've saved my day. I've been thinking endlessly to an extent I was developing headache. Thanks alot
You are so welcome!