Hello,

I have a spreadsheet with a running total and would like to count a sum only if there is an invoice number to the right of the cell.

I have attached the worksheet for you to see what I have created.

I also am having trouble grouping each month, I have subtotalled but although the calculations are correct, when I try to reduce the months down to just the total per month, it does not reduce all the dates.

I would appreciate your help. If I am only meant to ask one question per post, the first is priority.

Thanks

Attached Files

Example addif.xlsx (12.3 KB, 20 views)