View original (French)

=SUMIFS

Solved
nathan01983 Posted messages 30 Registration date   Status Member Last intervention   -  
nathan01983 Posted messages 30 Registration date   Status Member Last intervention   -
Hello

I would like to present my formula, which is in cell C10

=SUMIFS('S1'!G4:G17, 'S1'!D4:D17, ">="&C5, 'S1'!D4:D17, "<="&C6)

What I would like to be able to do is to write in C9 the text S1 or S2 or S3 and have my formula written a bit higher replace 'S1' with the value of cell C9.

Is this possible? Thank you in advance :)

1 answer

Answer 1 / 1
via55 Posted messages 14388 Registration date   Status Member Last intervention   2 755
 
Re,

Same process as in your other post, you need to use the INDIRECT function
=SUMIFS(INDIRECT("'" & C9 & "'!G4:G17"),INDIRECT("'" & C9 & "'!D4:D17"),">="&C5;,INDIRECT("'" & C9 & "'!D4:D17"),"<="&C6)

Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
1
nathan01983 Posted messages 30 Registration date   Status Member Last intervention   10
 
Perfect! And thank you very much!!!

I just want to correct my request but

=SUMIFS(INDIRECT("'" & $B$10 & "'!$G$4:$G$17"),INDIRECT("'" & $B$10 & "'!$D$4:$D$17"),">="&C5,INDIRECT("'" & $B$10 & "'!$D$4:$D$17"),"<="&C6)
0