One range, multiple sheets
Closed
AdioCK
-
Jul 29, 2009 at 02:12 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 29, 2009 at 05:59 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 29, 2009 at 05:59 AM
Related:
- One range, multiple sheets
- Sheets right to left - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- Photoshop multiple selections - Guide
- Apple airtag range - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 29, 2009 at 05:59 AM
Jul 29, 2009 at 05:59 AM
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.
=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.
