{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","OldSumIf","Sumproduct","Sumifs","Overview","Recap"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":1,"defined_names":12,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2043]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: aitoff / Pixabay"]

{"sheet":"OldSumIf","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Invoice","Rep","Product","Quantity",null,"Summary Table"]
[1001,"Richard Oldcorn","Widget",267]
[1002,"Allan Matz","Widget",221,null,"Name","Qty"]
[1003,"Rob Collie","Widget",371,null,"Allan Matz",{"$f":"SUMIF($B$2:$B$22,F4,$D$2:$D$22)","v":1543}]
[1004,"Rob Collie","Gadget",354,null,"Lorna Banuilos",{"$f":"SUMIF($B$2:$B$22,F5,$D$2:$D$22)","v":799}]
[1005,"Lorna Banuilos","Widget",236,null,"Richard Oldcorn",1940]
[1006,"Allan Matz","Widget",237,null,"Rob Collie",1688]
[1007,"Richard Oldcorn","Widget",292]
[1008,"Rob Collie","Widget",333]
[1009,"Richard Oldcorn","Gadget",296]
[1010,"Rob Collie","Widget",321]
[1011,"Allan Matz","Widget",286]
[1012,"Allan Matz","Widget",296]
[1013,"Richard Oldcorn","Widget",281]
[1014,"Lorna Banuilos","Widget",267]
[1015,"Rob Collie","Widget",309]
[1016,"Lorna Banuilos","Widget",296]
[1017,"Allan Matz","Widget",250]
[1018,"Richard Oldcorn","Widget",236]
[1019,"Allan Matz","Gadget",253]
[1020,"Richard Oldcorn","Widget",279]
[1021,"Richard Oldcorn","Gadget",289]

{"sheet":"Sumproduct","index":2,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Invoice","Rep","Product","Quantity",null,"Summary Table"]
[1001,"Richard Oldcorn","Widget",267]
[1002,"Allan Matz","Widget",221,null,"Name","Widget","Gadget"]
[1003,"Rob Collie","Widget",371,null,"Allan Matz",{"$f":"SUMPRODUCT(($B$2:$B$22=$F4)*($C$2:$C$22=G$3)*($D$2:$D$22))","v":1290},253]
[1004,"Rob Collie","Gadget",354,null,"Lorna Banuilos",799,0]
[1005,"Lorna Banuilos","Widget",236,null,"Richard Oldcorn",1355,585]
[1006,"Allan Matz","Widget",237,null,"Rob Collie",1334,354]
[1007,"Richard Oldcorn","Widget",292]
[1008,"Rob Collie","Widget",333]
[1009,"Richard Oldcorn","Gadget",296]
[1010,"Rob Collie","Widget",321]
[1011,"Allan Matz","Widget",286]
[1012,"Allan Matz","Widget",296]
[1013,"Richard Oldcorn","Widget",281]
[1014,"Lorna Banuilos","Widget",267]
[1015,"Rob Collie","Widget",309]
[1016,"Lorna Banuilos","Widget",296]
[1017,"Allan Matz","Widget",250]
[1018,"Richard Oldcorn","Widget",236]
[1019,"Allan Matz","Gadget",253]
[1020,"Richard Oldcorn","Widget",279]
[1021,"Richard Oldcorn","Gadget",289]

{"sheet":"Sumifs","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Invoice","Rep","Product","Quantity",null,"Summary Table"]
[1001,"Richard Oldcorn","Widget",267]
[1002,"Allan Matz","Widget",221,null,"Name","Widget","Gadget"]
[1003,"Rob Collie","Widget",371,null,"Allan Matz",{"$f":"SUMIFS($D$2:$D$22,$B$2:$B$22,$F4,$C$2:$C$22,G$3)","v":1290},{"$f":"SUMIFS($D$2:$D$22,$B$2:$B$22,$F4,$C$2:$C$22,H$3)","v":253}]
[1004,"Rob Collie","Gadget",354,null,"Lorna Banuilos",{"$f":"SUMIFS($D$2:$D$22,$B$2:$B$22,$F5,$C$2:$C$22,G$3)","v":799},0]
[1005,"Lorna Banuilos","Widget",236,null,"Richard Oldcorn",1355,585]
[1006,"Allan Matz","Widget",237,null,"Rob Collie",1334,354]
[1007,"Richard Oldcorn","Widget",292]
[1008,"Rob Collie","Widget",333]
[1009,"Richard Oldcorn","Gadget",296]
[1010,"Rob Collie","Widget",321]
[1011,"Allan Matz","Widget",286]
[1012,"Allan Matz","Widget",296]
[1013,"Richard Oldcorn","Widget",281]
[1014,"Lorna Banuilos","Widget",267]
[1015,"Rob Collie","Widget",309]
[1016,"Lorna Banuilos","Widget",296]
[1017,"Allan Matz","Widget",250]
[1018,"Richard Oldcorn","Widget",236]
[1019,"Allan Matz","Gadget",253]
[1020,"Richard Oldcorn","Widget",279]
[1021,"Richard Oldcorn","Gadget",289]

{"sheet":"Overview","index":4,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,"Excel 97","Excel 2007","Excel 2016","Excel vNext"]
[null,null,null,"Office 365 Feb 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Choose:","Central"]
[null,null,null,null,null,null,"Convert to Arabic:"]
[null,"East","CXI","TOTAL:",{"$f":"ROMANIFS($C$28:$C$36,$B$28:$B$36,E26)","v":{"$error":"#NAME?"}},null,{"$f":"_xlfn.ARABIC(C28)","v":111},{"$f":"_xlfn.FORMULATEXT(G28)","v":"=ARABIC(C28)"}]
[null,"Central","CXXI",null,null,null,{"$f":"_xlfn.ARABIC(C29)","v":121},{"$f":"_xlfn.FORMULATEXT(G29)","v":"=ARABIC(C29)"}]
[null,"West","CXXXI",null,null,null,131,"=ARABIC(C30)"]
[null,"East","L",null,null,null,50,"=ARABIC(C31)"]
[null,"Central","C",null,null,null,100,"=ARABIC(C32)"]
[null,"West","D",null,null,null,500,"=ARABIC(C33)"]
[null,"East","LXXV",null,null,null,75,"=ARABIC(C34)"]
[null,"Central","LXXXV",null,null,null,85,"=ARABIC(C35)"]
[null,"West","M",null,null,null,1000,"=ARABIC(C36)"]
[]
[null,null,null,null,null,null,"Total with SUMIF:"]
[null,null,null,null,null,null,{"$f":"SUMIF(B28:B36,E26,G28:G36)","v":306},{"$f":"_xlfn.FORMULATEXT(G39)","v":"=SUMIF(B28:B36,E26,G28:G36)"}]
[]
[null,null,null,null,null,null,"Convert back to Roman:"]
[null,null,null,null,null,null,{"$f":"ROMAN(G39)","v":"CCCVI"},{"$f":"_xlfn.FORMULATEXT(G42)","v":"=ROMAN(G39)"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IFERROR(E28,G42)","v":"CCCVI"},{"$f":"_xlfn.FORMULATEXT(E50)","v":"=IFERROR(E28,G42)"}]

{"sheet":"Recap","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Episode Recap"]
[]
[null,"SUMIF and COUNTIF have been around since Excel 97"]
[null,"They did not handle multiple conditions well - you had to use SUMPRODUCT"]
[null,"Starting in Excel 2007, the Excel team added plural versions: SUMIFS, COUNTIFS"]
[null,"They also shortened SUMIF()/COUNTIF into AVERAGEIF"]
[null,"And they added AVERAGEIFS"]
[null,"In the Feb 2016 release of Office 365, they added MAXIFS, MINIFS, IFS"]
[null,"But still no ROMANIFS"]
[null,"Thanks to Nathi Njoko, Abshir Osman, Scott Russell, and Ryan Sitoy."]
[null,"Excel Guru Mission Patch if you can figure out how ROMANIFS is working at the end."]