Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
bruneta99 pe Simpatie.ro
 | Femeie
25 ani
Satu Mare
cauta Barbat
25 - 50 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
I have a table with values and the header contains some codes for which I want to do the sum.
But I want to do the sum in another table, where the header codes are in a column.
- in T1:AP1 I have the codes for the data table
- in T3:AP108 is the data table
- in Q3:Q25 I have the codes from T1:AP1
- in R3:R25 I want to add the sums
In R3 I enter the following formula (CTRL+SHIFT+ENTER):
=SUM(IF($T$1:$AP$1=Q3;$T$3:$AP$108;0))
then I drag it down to Q25.
Source:
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|