I have a table which show like this day amt 3 (85.00)5 - 5 (694.44)13 - 60 (333.55)75 (416.03)88 - 92 - 95 -
I need to classified it into different days and then add the amt, for example according to 1 to 30 days, 31 to 91 days, 92 to 181 days and 182 and more. Now I am manually adding the amt according to the number of days, such as 1 to 30 days is 85 + 694 = 779.
May I know how do i write the IF and And function where every time the number of days is inputted, the worksheet will automatically calculated the total amt for me.
Thanks in advance.
I need to classified it into different days and then add the amt, for example according to 1 to 30 days, 31 to 91 days, 92 to 181 days and 182 and more. Now I am manually adding the amt according to the number of days, such as 1 to 30 days is 85 + 694 = 779.
May I know how do i write the IF and And function where every time the number of days is inputted, the worksheet will automatically calculated the total amt for me.
Thanks in advance.