Sum formula Visible cells only based on Column Header

Hi Team,

Need help in Sum Formula for Visible Cells only based on Column Header.

Attached is the sample format of the data which has below sheets:

Table Range RawData - This is rawdata which is formatted in Table range.
Snapshot - This is the sheet which snapshot where i have updated Slicers with Month & Employee Name based on the Table Range RawData.

Call Offered
Call Handled
Call Handled Within SLA

The above columns are unique headers in the Snapshot as well as Table Range RawData.

What i need is a Sum Formula which Sums up the columns from the Table Range RawData based on the header name only for the visible cells in the Table Range RawData when we filter the Data using Slicers.

Yellow is the highlighted space where i require the formula to be updated.

I would appreciate, if anyone could help on this please.

let me know for any clarifications.

Regards,
Yadavagiri

Hi TMS, thanks for your reply i tried what you suggested but that doesn't help as it shows the same values for all the employees when referred to total row

hi please help

Originally Posted by FDibbins

are you now able to respond to this thread?

Hi Sir,
It works once and again later when I reply again, it shows same error.

Pls help

If you are the site owner (or you manage this site), please whitelist your IP or if you think this block is an error please open a support ticket and make sure to include the block details (displayed in the box below), so we can assist you in troubleshooting the issue.

If i try to reply to my thread i get above message and error. sometime it allows to reply and most of the times i get the above message