- There is not the slightest explanation in your sheet
- You should explain what you are trying to do in words in your post. That way, members do not have to open your file to try to understand what you are trying to do
- Please also add manually calculated expected results
Thanx Pecoflyer Sir.
Also thank you Bosco Sir, given your SUMPRODUCT formula (Sheet 2) I am getting the Total of the column. Thank you.
Thank you very much Vletm Sir, I accomplish what I need by your given formula for Sheet 2.