Hello,
I've Excel with a lot of tabs which are tracking the working hours per day spent for various items.
I want to add all working hours per day in the main tab.
Here is very simplified example, I have a lot entries:
Tab1
<tbody>
</tbody>
Tab2
<tbody>
</tbody>
Main tab
<tbody>
</tbody>
I've tried with VLOOKUP, put date as an argument and then manually add each tab.
=IFERROR(VLOOKUP(A1;'Tab1'!$A$1:$F$8;5;FALSE);0)+IFERROR(VLOOKUP(A1;'Tab2'!$A$1:$F$8;5;FALSE);0)+…….
IFERROR is for the case if all tabs do not have the same number of entries because blank field returns wrong values
Problems:
What formulas should I use to achieve the good reslults?
I've Excel with a lot of tabs which are tracking the working hours per day spent for various items.
I want to add all working hours per day in the main tab.
Here is very simplified example, I have a lot entries:
Tab1
Date | Hours |
26.1.2019 | 20 |
27.1.2019 | 30 |
27.1.2019 | 5 |
<tbody>
</tbody>
Tab2
Date | Hours |
27.1.2019 | 30 |
28.1.2019 | 40 |
<tbody>
</tbody>
Main tab
Date | Sum hours |
26.1.2019 | 20 |
27.1.2019 | 65 |
28.1.2019 | 40 |
<tbody>
</tbody>
I've tried with VLOOKUP, put date as an argument and then manually add each tab.
=IFERROR(VLOOKUP(A1;'Tab1'!$A$1:$F$8;5;FALSE);0)+IFERROR(VLOOKUP(A1;'Tab2'!$A$1:$F$8;5;FALSE);0)+…….
IFERROR is for the case if all tabs do not have the same number of entries because blank field returns wrong values
Problems:
- If there are multiple entries for the same date in the tab only the value related to first date is added up. All the following entries with the same date are ignored
- I don't know how to dynamicly address different tabs so I don't have to add up manually each tab
What formulas should I use to achieve the good reslults?
Last edited: