Share via

Matrix formatting in excel sheet

Anonymous
2014-03-16T07:55:58+00:00

Hi,

i ve a really big problem, which couldn't solve till that time  about this worksheet. I wanna enter data to left side of this sheet and want to sum all the "TM" results in matrix automatically. in purple and orange datas can be change, i mean in this sample its going regular ( KK-KB-DP-DD-DK) and (52-53-60-61-65). These are just code, but grey rows are numbers which i want to sum...

So is there any basic way to update this matrix easily? because there will be much more than 1000 rows (6 rows datas is for one person). 

thanks...

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-03-16T16:35:50+00:00

    is there any help or suggestions?

    0 comments
  2. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2014-03-17T10:54:17+00:00

    Hi,

    Upload your file to OneDrive and share the link of the link of the uploaded file here.

    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2014-03-20T16:01:37+00:00

    I'm not sure if you're asking how to make cell formulas that get input from other cells and do calculations, or if you're asking about how to use Conditional Formatting to change the format of the cells after the calculation changes the cell value.

    0 comments