Tech Support Guy banner

Excel 2010 Pivot Table Summary

609 Views 0 Replies 1 Participant Last post by  BratDawg
Good afternoon. I am hoping someone here can help! I have exported an employee deduction for health insurance showing the Employee name and the Sum of Match for the Employer portion. I created a column where I could put Y or N for eligibility for IHS.

I now want to see if I can build an IF statement out to the side that counts if the value is Y in one cell and if it's N in the other. Assume Jim is A2, Donna A3, etc. There's a B column for the cost, but for this post it's irrelevant. I'm trying to determine how many of our employees are eligible for health insurance under a different program.

PIVOT Table Column A My Elig Y/N (Column C) My Tabulation of Y/N in Column E

Jim Smith Y Total Y = 4

Donna Jones N Total N = 1

Cindy Yep Y

Billy Bop Y

Jonny Q Y

Is that even possible?

Not open for further replies.
1 - 1 of 1 Posts
1 - 1 of 1 Posts
Not open for further replies.