Totals by Month

I use the attached worksheet to manage payments processed from PayPal.
I am looking to save a little work in the automatic caluculation of the figures in Col I 113 - 123 and in J 113 - 123
The calculation currently is done with a manual auto sum
I have place next to the cells what I would like to achieve.

Also I am seeking an alert in Col E should a duplicate Invoice number be attempted.

Assistance appreciated

I dont see what's wrong with the sum() formulas you have there now? if its a case of having to adjust them when you add a new month, then just take the sum range down to the empty row (25) and then add new rows above that when needed.

regarding the duplicates, this can be done with conditional formatting...
1. highlight the range you want to apply the conditional formatting to (E8:E104)
2. on the home tab, styles, select CF
3. select new rule, select "format only unique or duplicate values"
4. select duplicates - format fill as desired

hope this helps?

for the formulas in G125:J125? why, they are working fine?

ok if i understand you, in I113, copied down and across, use this...
=SUMIFS($G$7:$G$104,$A$7:$A$104,">="&$D113,$A$7:$A$104,"<"&$D114,$D$7:$D$104,I$112)

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, consider thanking those who helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

I am greatly appreciating the assistance given.
I have a further thought and a request for assistance

The form which I have attached an example is added to on a daily basis and it is quiet a pain to insert blank cells [eg from row 65 onwards]
Is it possible for code that adds a line to when info is added into the next line
In other words
If I enter info into row 65 can it auto add a row to accept additional info rather than what I have now a lot of empty green Rows

Appreciate assistance

I made some changes to your file. I put the data on sheet2, and changed some of your formulas (and the CF)

also adjusted the formulas on the summary table to include a longer rtange. take a look an let me know what you think?

(on your data sheet - sheet2, check the name headings on I5:J5, i think you have them the wrong way round?

Or with an pivot table.

See the attached file.

not sure if post # 12 is the same request as post # 9, but if you take a look at the file that I uploaded, the formulas continue down to row 104?

you can easily copy that format down another couple of hundred rows if you want to, you dont need any code that will "add a row when data in one row has been completed"