Hi,
I need a formula that will sum up the total usage for all users of each report. For example, i need to formula in Column F to sum up Report 1's usage (Which would be 25 as there is only 1 user), and then sum up Report 2's usage (Which would be 65) etc. But what i also need is for numbers to only appear where the report name is. For example, for Report 2 i'd need the 65 to appear in D3, and then the rest of the cells be blank until D18 for Report 3's total usage, and then blank up until Report 4 etc.
img1.PNG
I've attached the example file.
I hope that all make sense, but let me know if not.
Many thanks,
swood
Bookmarks