I have a project at work for an invoice statement to send to customers, and it can not seem to get excel to work for me.
Column A Invoice Date Column B Invoice Column C Charges Column D Credits Column E Balance
However at the bottom she wants the current (A), Over 30 days(B), Over 60 days(C), and Over 90(D) days balance to show in each spot.
The problem I seem to have is that I can get it to work with =SUMIF, but if I try to subtract the credits column It says too many arguments or just says I have an error.
I'm using Excel 2011 on a MAC
(why this employer insists on MACs I have no idea)
Column A Invoice Date Column B Invoice Column C Charges Column D Credits Column E Balance
However at the bottom she wants the current (A), Over 30 days(B), Over 60 days(C), and Over 90(D) days balance to show in each spot.
The problem I seem to have is that I can get it to work with =SUMIF, but if I try to subtract the credits column It says too many arguments or just says I have an error.
I'm using Excel 2011 on a MAC
(why this employer insists on MACs I have no idea)