{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sales Summary","Method 2","VBA","Quarter 1","Quarter 2","Quarter 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sales Summary","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Sumif Across Multiple Sheets"]
["Method 1: SUMIF for Each Sheet"]
[]
[null,"Salesman","Yearly Sales"]
[null,"Mark",{"$f":"SUMIF('Quarter 1'!B5:B9,'Sales Summary'!B5,'Quarter 1'!C5:C9)+SUMIF('Quarter 2'!B5:B9,'Sales Summary'!B5,'Quarter 2'!C5:C9)+SUMIF('Quarter 3'!B5:B9,'Sales Summary'!B5,'Quarter 3'!C5:C9)","v":299500}]
[null,"Harold",{"$f":"SUMIF('Quarter 1'!B6:B10,'Sales Summary'!B6,'Quarter 1'!C6:C10)+SUMIF('Quarter 2'!B6:B10,'Sales Summary'!B6,'Quarter 2'!C6:C10)+SUMIF('Quarter 3'!B6:B10,'Sales Summary'!B6,'Quarter 3'!C6:C10)","v":269650}]
[null,"Root",{"$f":"SUMIF('Quarter 1'!B7:B11,'Sales Summary'!B7,'Quarter 1'!C7:C11)+SUMIF('Quarter 2'!B7:B11,'Sales Summary'!B7,'Quarter 2'!C7:C11)+SUMIF('Quarter 3'!B7:B11,'Sales Summary'!B7,'Quarter 3'!C7:C11)","v":292050}]
[null,"Jhon",{"$f":"SUMIF('Quarter 1'!B8:B12,'Sales Summary'!B8,'Quarter 1'!C8:C12)+SUMIF('Quarter 2'!B8:B12,'Sales Summary'!B8,'Quarter 2'!C8:C12)+SUMIF('Quarter 3'!B8:B12,'Sales Summary'!B8,'Quarter 3'!C8:C12)","v":279000}]
[null,"Antony",{"$f":"SUMIF('Quarter 1'!B9:B13,'Sales Summary'!B9,'Quarter 1'!C9:C13)+SUMIF('Quarter 2'!B9:B13,'Sales Summary'!B9,'Quarter 2'!C9:C13)+SUMIF('Quarter 3'!B9:B13,'Sales Summary'!B9,'Quarter 3'!C9:C13)","v":239270}]

{"sheet":"Method 2","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Sumif Across Multiple Sheets"]
["Method 2: SUMPRODUCT AND SUMIF"]
[]
[null,"Salesman","Yearly Sales",null,"Quarter"]
[null,"Mark",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$E$5:$E$7&\"'!$B$5:$B$9\"),B5,INDIRECT(\"'\"&$E$5:$E$7&\"'!$C$5:$C$9\")))","v":299500},null,"Quarter 1"]
[null,"Harold",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$E$5:$E$7&\"'!$B$5:$B$9\"),B6,INDIRECT(\"'\"&$E$5:$E$7&\"'!$C$5:$C$9\")))","v":269650},null,"Quarter 2"]
[null,"Root",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$E$5:$E$7&\"'!$B$5:$B$9\"),B7,INDIRECT(\"'\"&$E$5:$E$7&\"'!$C$5:$C$9\")))","v":292050},null,"Quarter 3"]
[null,"Jhon",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$E$5:$E$7&\"'!$B$5:$B$9\"),B8,INDIRECT(\"'\"&$E$5:$E$7&\"'!$C$5:$C$9\")))","v":279000}]
[null,"Antony",{"$f":"SUMPRODUCT(SUMIF(INDIRECT(\"'\"&$E$5:$E$7&\"'!$B$5:$B$9\"),B9,INDIRECT(\"'\"&$E$5:$E$7&\"'!$C$5:$C$9\")))","v":239270}]

{"sheet":"VBA","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Sumif Across Multiple Sheets"]
["Method 3: VBA"]
[]
[null,"Salesman","Yearly Sales"]
[null,"Mark",{"$f":"SUMIFOS(B5,'Quarter 1'!B5:B9,'Quarter 1'!C5:C9,'Quarter 2'!B5:B9,'Quarter 2'!C5:C9,'Quarter 3'!B5:B9,'Quarter 3'!C5:C9)","v":299500}]
[null,"Harold",{"$f":"SUMIFOS(B6,'Quarter 1'!B6:B10,'Quarter 1'!C6:C10,'Quarter 2'!B6:B10,'Quarter 2'!C6:C10,'Quarter 3'!B6:B10,'Quarter 3'!C6:C10)","v":269650}]
[null,"Root",{"$f":"SUMIFOS(B7,'Quarter 1'!B7:B11,'Quarter 1'!C7:C11,'Quarter 2'!B7:B11,'Quarter 2'!C7:C11,'Quarter 3'!B7:B11,'Quarter 3'!C7:C11)","v":292050}]
[null,"Jhon",{"$f":"SUMIFOS(B8,'Quarter 1'!B8:B12,'Quarter 1'!C8:C12,'Quarter 2'!B8:B12,'Quarter 2'!C8:C12,'Quarter 3'!B8:B12,'Quarter 3'!C8:C12)","v":279000}]
[null,"Antony",{"$f":"SUMIFOS(B9,'Quarter 1'!B9:B13,'Quarter 1'!C9:C13,'Quarter 2'!B9:B13,'Quarter 2'!C9:C13,'Quarter 3'!B9:B13,'Quarter 3'!C9:C13)","v":239270}]

{"sheet":"Quarter 1","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Sumif Across Multiple Sheets"]
[]
[]
[null,"Salesman","Sales"]
[null,"Mark",98500]
[null,"Harold",76900]
[null,"Root",102450]
[null,"Jhon",78000]
[null,"Antony",75000]

{"sheet":"Quarter 2","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Sumif Across Multiple Sheets"]
[]
[]
[null,"Salesman","Sales"]
[null,"Mark",92500]
[null,"Harold",86450]
[null,"Root",92650]
[null,"Jhon",98000]
[null,"Antony",68600]

{"sheet":"Quarter 3","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Sumif Across Multiple Sheets"]
[]
[]
[null,"Salesman","Sales"]
[null,"Mark",108500]
[null,"Harold",106300]
[null,"Root",96950]
[null,"Jhon",103000]
[null,"Antony",95670]