Hello,
I have the below two sheets Sheet 1 and Sheet 2 ( the one with the VALUE error) and in Sheet2 I'm trying to obtain the sum of the totals from Sheet1 using a formula with multiple criteria. E.g. I want to see in Sheet2 the results of all the Vichy, Xerolys and Home but only for a specific column: If in Sheet2 in cell A1 I have number 5 then I want the formula to add up the totals from the column corresponding to 5 in Sheet1 ( 87, 14, 26). The formula that I've tried to use is #=SUMIFS(Sheet1!$B$5:$F$7,Sheet1!$A$5:$A$7,Sheet2!A4,Sheet1!$B$3:$F$3,Sheet2!$A$1)# but I receive a VALUE error. Can anyone help?
Thank you,
Sheet1
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
and
Sheet2
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I have the below two sheets Sheet 1 and Sheet 2 ( the one with the VALUE error) and in Sheet2 I'm trying to obtain the sum of the totals from Sheet1 using a formula with multiple criteria. E.g. I want to see in Sheet2 the results of all the Vichy, Xerolys and Home but only for a specific column: If in Sheet2 in cell A1 I have number 5 then I want the formula to add up the totals from the column corresponding to 5 in Sheet1 ( 87, 14, 26). The formula that I've tried to use is #=SUMIFS(Sheet1!$B$5:$F$7,Sheet1!$A$5:$A$7,Sheet2!A4,Sheet1!$B$3:$F$3,Sheet2!$A$1)# but I receive a VALUE error. Can anyone help?
Thank you,
Sheet1
1 | 2 | 3 | 4 | 5 | |
Vichy | 45 | 43 | 56 | 65 | 87 |
Xerolys | 23 | 43 | 65 | 899 | 14 |
Home | 1345 | 65 | 565 | 76 | 26 |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
and
Sheet2
5 | |
Total | |
Vichy | #VALUE! |
Xerolys | |
Home |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>