hi,
Is it possible to add mutilple rows based on a condition. Say for Example, if i have sales numbers by months and if i want to YTD sales number based on the month i have selected. I have attached an excel sheet for example.
hi,
Is it possible to add mutilple rows based on a condition. Say for Example, if i have sales numbers by months and if i want to YTD sales number based on the month i have selected. I have attached an excel sheet for example.
Re: YTD calculation
Hi Yogin
This should get you over the line if you change your text dates to real dates. 1/1/2011 for Jan, 1/2/2011 for Feb and have the criteria in the same formate ie B8 is 1/05/2011
=SUMPRODUCT(($A$2:$A$4=$A9)*($B$1:$M$1<=$B$8)*($B$2:$M$4))
Take care
Smallman
Don’t have an account yet? Register yourself now and be a part of our community!