[Closed] Exceltrackworld assemble. Query no. 5379643

Hello

I have a worksheet which captures live data which is then archived by me at the month end. I just cut and paste into another tab called 'archive '

I've created pivot tables on a report tab with two tables. One summarises the live data sheet and the other summarises the archived data. The pivot tables just show the count of each department I'm recording.

I'd like to be able to add a number to these totals as there's historic totals data I've been given which needs to be added to live and archive totals.

Can one add a number to pivot table totals or should I find another way like using COUNTIF?

The fly in the ointment is that some lines in the live sheet as requesting those rows be deleted. Is there a way of recording just the others and not deletions?

I hope I've not sent you insane!

Thanks