Previous Topic Next Topic

Find values based on colum and sum in a table

Closed
lotusscript - Mar 16, 2012 at 06:38 PM
 Blocked Profile - Mar 18, 2012 at 12:24 AM
Hello,



I have an Excel spreadsheet where I pull in data from another source into columns A1-BS. I then want to look at the last line, here the 3/15/2012 12:43:56 and get the number. This could change and the first column might not be 3, New

I want to look at 3 and New and know the value 1 needs to be placed in the new 3 table cell below. Any suggestions on how to handle this????

3 3
Date / Time New In Progress
03/15/2012 12:27:28 1 0
03/15/2012 12:41:36 1 0
03/15/2012 12:43:56 1 0


| SEVERITY |
STATE | 1 2 3 4 5 |TOTAL
---------- ------ ------ ------ ------- ----- ------ --
new | 0 0 1 0 0 | 1
in progress | 0 0 0 0 0 | 0
resolved | 0 0 0 1 0 | 1
feedback | 0 0 0 0 0 | 0
closed | 0 0 0 0 0 | 0
rejected | 1 0 0 0 0 | 1
review | 0 0 0 0 0 | 0
returned | 0 0 0 0 0 | 0
reviewing | 0 0 0 0 0 | 0
merging | 0 0 0 0 0 | 0
testing | 0 0 0 0 0 | 0
---------- ------ ------ ------ ------- ----- ------ --
TOTAL | 1 0 1 1 0 3
Related:

1 reply

Answer 1 / 1
Blocked Profile
Mar 18, 2012 at 12:24 AM
Greetings,

Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from Kioskea forum users correspond showing mutual respect. Therefore, when requesting assistance, the use of polite expressions,as for elsewhere in similar circumstances, is appreciated. (please, thank you, appreciate, grateful, etc.)

https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/#politesse

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator
0