Tuesday, November 20, 2018

Excel SUMIFS

I declare victory!
=SUMIFS(massmurder!$H$2:$H$300,massmurder!$A$2:$A$300,"<>1*",massmurder!$A$2:$A$300,"<>2*",massmurder!K2:K300,"1")
This adds the H column (number dead) for every row that does not have a decade in column A (either 1* or 2*) and the corresponding weapon type column has a 1.

I have since realized that it is more meaningful to see what mass murders were committed with a single weapon.  This was bit more complicated.  Here is a typical formua:
AX
=SUMIFS(massmurder!$H$2:$H$1500,massmurder!$A$2:$A$1500,"<>1*",massmurder!$A$2:$A$1500,"<>2*",massmurder!K2:K1500,"=",massmurder!M2:M1500,"=",massmurder!N2:N1500,"=",massmurder!O2:O1500,"=",massmurder!P2:P1500,"=",massmurder!Q2:Q1500,"=",massmurder!R2:R1500,"=",massmurder!S2:S1500,"=",massmurder!T2:T1500,"=",massmurder!U2:U1500,"=",massmurder!V2:V1500,"=",massmurder!W2:W1500,"=",massmurder!X2:X1500,"=",massmurder!Y2:Y1500,"=",massmurder!Z2:Z1500,"=",massmurder!AA2:AA1500,"=",massmurder!AB2:AB1500,"=",massmurder!AC2:AC1500,"=")
And yes, I used emacs to construct all these equations.

No comments: