hi,
i have a sheet having car number (D column),year of purchase (E column), accumulated at end of year (I column) and total cost (Q column)..
my problem is for example the car number 12 ...
i need to get the value in one cell like this ....
sum up the I column according to year ,car number and the sum up value should be less than total cost(Q column). if it is greater than total cost then need to keep total value....
problem is the cell range or cell address don't know. they are generated.
how to do that.... can any one help me please
New Microsoft Office Excel Worksheet.xlsx
Bookmarks