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, 18 views)

You could insert the following formula into C7 and copy down as far as needed:
=IF(E7<>0,$H$1*(ROW()-MATCH("*",B$1:B6,-1)-1),"")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

This formula works great up until cell C14 but does not carry down to the other totals, i.e. C32 & C47.

I have tried to make a few minor changes to the formula but can't seem to get it to work.

Any ideas?

Thanks

As written the formula looks for an invoice amount in column E. I mis-read your requirements. To have it for an invoice # in column D, use:
=IF(D7<>0,$H$1*(ROW()-MATCH("*",B$1:B6,-1)-1),"")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Worked lovely, thanks :-)