One range, multiple sheets [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hey guys

I'd like to know how i can add 3 different sheets into one range.

For example, i have the =sumif(range,

How can i fit info from sheet 1 'sheet-ONE'!C5:H16, 'sheet-TWO'!C5:H16, and sheet 3 'sheet-THREE'!C5:H16

into the one Range i have for the sumif function?

i've tried
'sheet-ONE'!C5:H16&'sheet-TWO'!C5:H16&'sheet-THREE'!C5:H16
and +.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
792
is the crietira for sum if common or variable try somethig like this

=SUMIF(Sheet1!A1:A3,">3")+SUMIF(Sheet2!A1:A3,">3")+SUMIF(Sheet3!A1:A3,">3")

if you can write a macro it will be also ok.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!