Hello:
Please refer to attached sheet.
We get checks from Client and i add them up in excel sheet as is shown in column B,C,D,E,etc
Sum of checks is in Row 4.
I need a formula for Row 3, to calculate the average per check for that particular deposits.
Example : Column B , Total of all checks was $4865.80 consisting of 75 checks so averge would be
$4865.80/75 = $64.88 This would need to be in B3
Similarly C3 = 7145.01/136 = $52.54
D3
E3, etc.....
Please let me know if you have any questions.
Thank you in advanve for your help.
RM
Bookmarks