Home

Sum If Then formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-681200%22%20slang%3D%22en-US%22%3ESum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681200%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20formula%2C%20I%20think%20it's%20going%20to%20be%20a%20If%20Then%20sum%20formula%2C%20but%20I%20haven't%20had%20a%20lot%20of%20luck%20trying%20to%20figure%20this%20out%20on%20my%20own.%20In%20my%20example%2C%20I%20want%20to%20sum%20the%20payment%20amount%20(E)%2C%20if%20the%20date%20field%20(B)%26nbsp%3Band%20the%20form%20of%20payment%20field%20(D)%26nbsp%3Bare%20the%20same.%20Any%20help%20would%20be%20greatly%20appreciated!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3EE%3C%2FTD%3E%3CTD%3EF%3C%2FTD%3E%3CTD%3EG%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F2%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905020004%3C%2FTD%3E%3CTD%3E%24376.05%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F2%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905020002%3C%2FTD%3E%3CTD%3E%24253.21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F4%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905040002%3C%2FTD%3E%3CTD%3E%24170.04%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F6%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905060002%3C%2FTD%3E%3CTD%3E%24530.71%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F6%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905060001%3C%2FTD%3E%3CTD%3E%24504.67%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F7%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EDiscover%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905070006%3C%2FTD%3E%3CTD%3E%241%2C098.72%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F7%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EDiscover%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905070007%3C%2FTD%3E%3CTD%3E(%241%2C098.72)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F7%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905070012%3C%2FTD%3E%3CTD%3E%24327.10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F8%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905080003%3C%2FTD%3E%3CTD%3E%241%2C030.90%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F8%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905080004%3C%2FTD%3E%3CTD%3E%24257.23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3EC%26amp%3BC%20ASPHALT%20INC.%3C%2FTD%3E%3CTD%3EAmerican%20Express%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905150005%3C%2FTD%3E%3CTD%3E%24284.45%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3EHOOD%2C%20LARRY%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905150006%3C%2FTD%3E%3CTD%3E%24561.68%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F16%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905160002%3C%2FTD%3E%3CTD%3E%241%2C340.91%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F17%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905170003%3C%2FTD%3E%3CTD%3E%241%2C526.20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F17%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905170001%3C%2FTD%3E%3CTD%3E%241%2C276.19%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDecatur%3C%2FTD%3E%3CTD%3E5%2F20%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20DECATUR%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E211905200001%3C%2FTD%3E%3CTD%3E%24378.01%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-681200%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681308%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357698%22%20target%3D%22_blank%22%3E%40Jon-W%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20how%20you'd%20like%20organize%20the%20result.%20If%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20402px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117660i0B07DA43BB2440B7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ethen%3C%2FP%3E%0A%3CPRE%3E%3DSUMIFS(%24G%3A%24G%2C%24D%3A%24D%2CJ%241%2C%24B%3A%24B%2C%24I2)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681368%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20how%20I%20need%20to%20format%20it%2C%20this%20is%20how%20it%20looks%20when%20I%20just%20add%20it%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F2%2F2019%3C%2FTD%3E%3CTD%3EPROCONTRACTOR%20SUPPLY%2C%20INC.%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%24855.00%3C%2FTD%3E%3CTD%3E551905020002%3C%2FTD%3E%3CTD%3E%24855.00%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F3%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%24254.40%3C%2FTD%3E%3CTD%3E551905030006%3C%2FTD%3E%3CTD%3E%24254.40%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F3%2F2019%3C%2FTD%3E%3CTD%3EMAX%20JONES%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%241%2C470.40%3C%2FTD%3E%3CTD%3E551905030004%3C%2FTD%3E%3CTD%3E%241%2C470.40%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F4%2F2019%3C%2FTD%3E%3CTD%3EAPEX%20SEAL%20COATINGS%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%24482.72%3C%2FTD%3E%3CTD%3E551905040001%3C%2FTD%3E%3CTD%3E%24482.72%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F6%2F2019%3C%2FTD%3E%3CTD%3EAPEX%20SEAL%20COATINGS%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%24321.82%3C%2FTD%3E%3CTD%3E551905060001%3C%2FTD%3E%3CTD%3E%24321.82%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F14%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%24281.59%3C%2FTD%3E%3CTD%3E551905140007%3C%2FTD%3E%3CTD%3E%24281.59%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E551905150006%3C%2FTD%3E%3CTD%3E%2458.29%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%24411.27%3C%2FTD%3E%3CTD%3E551905150012%3C%2FTD%3E%3CTD%3E%24352.98%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F16%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%24136.21%3C%2FTD%3E%3CTD%3E551905160005%3C%2FTD%3E%3CTD%3E%24136.21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F23%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%24154.74%3C%2FTD%3E%3CTD%3E551905230003%3C%2FTD%3E%3CTD%3E%24154.74%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F24%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E551905240006%3C%2FTD%3E%3CTD%3E%24529.47%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F24%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%24618.50%3C%2FTD%3E%3CTD%3E551905240007%3C%2FTD%3E%3CTD%3E%2489.03%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F28%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%24437.23%3C%2FTD%3E%3CTD%3E551905280006%3C%2FTD%3E%3CTD%3E%24437.23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F29%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EMaster%20Card%3C%2FTD%3E%3CTD%3E%24335.23%3C%2FTD%3E%3CTD%3E551905290002%3C%2FTD%3E%3CTD%3E%24335.23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKennesaw%3C%2FTD%3E%3CTD%3E5%2F29%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20KENNESAW%3C%2FTD%3E%3CTD%3EVisa%3C%2FTD%3E%3CTD%3E%24719.38%3C%2FTD%3E%3CTD%3E551905290005%3C%2FTD%3E%3CTD%3E%24719.38%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681413%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681413%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357698%22%20target%3D%22_blank%22%3E%40Jon-W%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20do%20records%20sorted%20by%20dates%20in%20ascending%20order%20and%20when%20by%20card%20type%3F%20Or%20for%20the%20same%20date%20records%20could%20be%20like%3C%2FP%3E%0A%3CP%3EVisa%3C%2FP%3E%0A%3CP%3EMasterCard%3C%2FP%3E%0A%3CP%3EVisa%3C%2FP%3E%0A%3CP%3EMasterCard%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681426%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681426%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20are%20sorted%20first%20by%20date%2C%20then%20by%20card%20type.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681435%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357698%22%20target%3D%22_blank%22%3E%40Jon-W%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20it%20could%20be%20like%20in%20column%20I%20in%20Sheet2%20attached%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20686px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117678i0DB9F1F962E2849A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3DIF((%24B1%3D%24B2)*(%24D1%3D%24D2)%2C%22%22%2CSUMIFS(%24G%3A%24G%2C%24B%3A%24B%2C%24B1%2C%24D%3A%24D%2C%24D1))%3C%2FPRE%3E%0A%3CP%3EStart%20from%20row%201%20and%20drag%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681506%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681506%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20EXACTLY%20what%20I%20need%2C%20but%20I'm%20not%20an%20Excel%20expert%2C%20and%20can't%20figure%20out%20how%20you%20got%20the%20formula%20into%20that%20whole%20row.%20When%20I%20use%20formulas%2C%20so%20far%20they%20have%20been%20basic.%20%3DA1*A2%20and%20then%20I%20would%20copy%20and%20paste%20that%20formula%20into%20all%20the%20cells%20below%20it.%20This%20what%20I'm%20coming%20up%20with%20when%20I%20try%20your%20formula.%20I%20will%20paste%20here%2C%20and%20then%20link%20a%20copy%20of%20the%20excel%20file.%20And%20thank%20you%20so%20much%20for%20your%20help!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDate%3C%2FTD%3E%3CTD%3ECustomerName%3C%2FTD%3E%3CTD%3EPayment%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ESaleNum%3C%2FTD%3E%3CTD%3EAmount%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F1%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E462%3C%2FTD%3E%3CTD%3E471905010002%3C%2FTD%3E%3CTD%3E%24462.00%3C%2FTD%3E%3CTD%3E%3DIF((%24B2%3D%24B3)*(%24D2%3D%24D3)%2C%22%22%2CSUMIFS(%23REF!%2C%24B2%3A%24B21%2C%24B2%2C%24D2%3A%24D21%2C%24D2))%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F2%2F2019%3C%2FTD%3E%3CTD%3EB%20%26amp%3B%20T%20LABORING%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%24190.30%3C%2FTD%3E%3CTD%3E471905020005%3C%2FTD%3E%3CTD%3E%24190.30%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F8%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E93.5%3C%2FTD%3E%3CTD%3E471905080006%3C%2FTD%3E%3CTD%3E%2493.50%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F9%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E27.5%3C%2FTD%3E%3CTD%3E471905090007%3C%2FTD%3E%3CTD%3E%2427.50%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F13%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905130002%3C%2FTD%3E%3CTD%3E%24492.80%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F13%2F2019%3C%2FTD%3E%3CTD%3E2018%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E156.75%3C%2FTD%3E%3CTD%3E471905130006%3C%2FTD%3E%3CTD%3E%24156.75%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3EWARREN%20ASPHALT%20CONSTRUCTION%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905150003%3C%2FTD%3E%3CTD%3E%248.79%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3E2018%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905150004%3C%2FTD%3E%3CTD%3E%24331.91%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3E2018%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905150006%3C%2FTD%3E%3CTD%3E%24165.54%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3E2018%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905150007%3C%2FTD%3E%3CTD%3E%242.75%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F15%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E64.89%3C%2FTD%3E%3CTD%3E471905150008%3C%2FTD%3E%3CTD%3E%2464.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F18%2F2019%3C%2FTD%3E%3CTD%3EBIG%20JOHN'S%20ASPHALT%20PAVING%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E13.2%3C%2FTD%3E%3CTD%3E471905180002%3C%2FTD%3E%3CTD%3E%2413.20%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F21%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E492.8%3C%2FTD%3E%3CTD%3E471905210002%3C%2FTD%3E%3CTD%3E%24492.80%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F23%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905230001%3C%2FTD%3E%3CTD%3E%24372.89%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F23%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905230008%3C%2FTD%3E%3CTD%3E%24367.40%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F23%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E943.8%3C%2FTD%3E%3CTD%3E471905230009%3C%2FTD%3E%3CTD%3E%24943.80%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F24%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E471905240002%3C%2FTD%3E%3CTD%3E%24243.91%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F24%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E722.7%3C%2FTD%3E%3CTD%3E471905240008%3C%2FTD%3E%3CTD%3E%24722.70%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F25%2F2019%3C%2FTD%3E%3CTD%3ESOUTHERN%20SEALS%20AND%20STRIPES%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E724.9%3C%2FTD%3E%3CTD%3E471905250002%3C%2FTD%3E%3CTD%3E%24724.90%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F31%2F2019%3C%2FTD%3E%3CTD%3E2019%20CASH%20BIRMINGHAM%3C%2FTD%3E%3CTD%3ECash%3C%2FTD%3E%3CTD%3E176%3C%2FTD%3E%3CTD%3E471905310005%3C%2FTD%3E%3CTD%3E%24176.00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-681543%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-681543%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357698%22%20target%3D%22_blank%22%3E%40Jon-W%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20your%20case%20formula%20will%20be%20like%3C%2FP%3E%0A%3CPRE%3E%3DIF((%24A2%3D%24A3)*(%24C2%3D%24C3)%2C%22%22%2CSUMIFS(%24F%242%3A%24F2%2C%24A%242%3A%24A2%2C%24A2%2C%24C%242%3A%24C2%2C%24C2))%3C%2FPRE%3E%0A%3CP%3EBe%20careful%20which%20columns%20to%20take%20for%20the%20calculation%20and%20with%20absolute%20%2F%20relative%20references.%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECondition%20parameter%20in%20IF%20checks%20if%20the%20date%20AND%20payment%20method%20are%20the%20same%20in%20the%20current%20and%20next%20row.%20If%20so%20then%20empty%20string.%20If%20no%2C%20then%20SUMIFS%20calculates%20sum%20of%20all%20payments%20from%20first%20to%20current%20row%20for%20which%20the%20date%20and%20payment%20method%20are%20are%20the%20same%20as%20for%20current%20row.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-682025%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682025%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20a%20life%20saver!!%20I%20have%20one%20more%20snag%2C%20and%20probably%20something%20I%20should%20have%20mentioned%20earlier.%20In%20this%20sheet%2C%20there%20are%20multiple%20locations%2C%20which%20might%20have%20transactions%20on%20the%20same%20day%20for%20the%20same%20form%20of%20payment.%20I%20have%204%20locations%2C%20the%20formula%20you%20gave%20works%20perfect%20for%20the%20first%20store%2C%20but%20on%20the%20second%20store%2C%20it%20starts%20to%20add%20the%20totals%20from%20the%20first%20store.%3C%2FP%3E%3CP%3EThis%20is%20your%20formula%3C%2FP%3E%3CP%3E%3DIF((%24B1%3D%24B2)*(%24D1%3D%24D2)%2C%22%22%2CSUMIFS(%24G%3A%24G%2C%24B%3A%24B%2C%24B1%2C%24D%3A%24D%2C%24D1))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20your%20formula%2C%20tweaked%20for%20my%20sheet%2C%20that%20does%20work%20on%20the%20different%20categories%20for%20my%20first%20store%3C%2FP%3E%3CP%3E%3DIF((%24B2%3D%24B3)*(%24D2%3D%24D3)%2C%22%22%2CSUMIFS(%24G%242%3A%24G2%2C%24B%242%3A%24B2%2C%24B2%2C%24D%242%3A%24D2%2C%24D2))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20what%20I%20came%20up%20with%20when%20I%20tried%20to%20add%20a%203rd%20condition%3C%2FP%3E%3CP%3E%3DIF((%24B2%3D%24B3)*(%24D2%3D%24D3)*(%24A2%3D%24A3)%2C%22%22%2CSUMIFS(%24G%242%3A%24G2%2C%24B%242%3A%24B2%2C%24B2%2C%24D%242%3A%24D2%2C%24D2))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20still%20worked%20for%20the%20first%20location%2C%20but%20then%20added%20the%20daily%20total%20from%20the%20store%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20again%2C%20I%20appreciate%20the%20help%20so%20much!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-684774%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684774%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%3F%20You%20have%20been%20such%20a%20help%20so%20far!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-684975%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684975%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357698%22%20target%3D%22_blank%22%3E%40Jon-W%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20missed%20your%20question.%20That%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DIF(%24A2%3D%22%22%2C%22%22%2CIF((%24B2%3D%24B3)*(%24D2%3D%24D3)*(%24A2%3D%24A3)%2C%22%22%2CSUMIFS(%24G%242%3A%24G2%2C%24B%242%3A%24B2%2C%24B2%2C%24D%242%3A%24D2%2C%24D2%2C%24A%242%3A%24A2%2C%24A2%2C%24A%242%3A%24A2%2C%22%26lt%3B%26gt%3B%22)))%3C%2FPRE%3E%0A%3CP%3Ein%20cell%20E2%20and%20drag%20it%20down%20till%20end%20of%20the%20range%20over%20all%20locations.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686824%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20THE%20BEST!!%20Thank%20you%20so%20much%20for%20your%20help!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687157%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20If%20Then%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687157%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357698%22%20target%3D%22_blank%22%3E%40Jon-W%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20welcome%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jon-W
Occasional Contributor

I need help with a formula, I think it's going to be a If Then sum formula, but I haven't had a lot of luck trying to figure this out on my own. In my example, I want to sum the payment amount (E), if the date field (B) and the form of payment field (D) are the same. Any help would be greatly appreciated!!

 

ABCDEFG
Decatur5/2/20192019 CASH DECATURMaster Card 211905020004$376.05
Decatur5/2/20192019 CASH DECATURVisa 211905020002$253.21
Decatur5/4/20192019 CASH DECATURVisa 211905040002$170.04
Decatur5/6/20192019 CASH DECATURMaster Card 211905060002$530.71
Decatur5/6/20192019 CASH DECATURVisa 211905060001$504.67
Decatur5/7/20192019 CASH DECATURDiscover 211905070006$1,098.72
Decatur5/7/20192019 CASH DECATURDiscover 211905070007($1,098.72)
Decatur5/7/20192019 CASH DECATURMaster Card 211905070012$327.10
Decatur5/8/20192019 CASH DECATURVisa 211905080003$1,030.90
Decatur5/8/20192019 CASH DECATURVisa 211905080004$257.23
Decatur5/15/2019C&C ASPHALT INC.American Express 211905150005$284.45
Decatur5/15/2019HOOD, LARRYVisa 211905150006$561.68
Decatur5/16/20192019 CASH DECATURMaster Card 211905160002$1,340.91
Decatur5/17/20192019 CASH DECATURMaster Card 211905170003$1,526.20
Decatur5/17/20192019 CASH DECATURVisa 211905170001$1,276.19
Decatur5/20/20192019 CASH DECATURMaster Card 211905200001$378.01
12 Replies

@Jon-W ,

 

It depends on how you'd like organize the result. If like

image.png

then

=SUMIFS($G:$G,$D:$D,J$1,$B:$B,$I2)

@Sergei Baklan 

 

This is how I need to format it, this is how it looks when I just add it myself.

 

Kennesaw5/2/2019PROCONTRACTOR SUPPLY, INC.Master Card$855.00551905020002$855.00
Kennesaw5/3/20192019 CASH KENNESAWMaster Card$254.40551905030006$254.40
Kennesaw5/3/2019MAX JONESVisa$1,470.40551905030004$1,470.40
Kennesaw5/4/2019APEX SEAL COATINGSMaster Card$482.72551905040001$482.72
Kennesaw5/6/2019APEX SEAL COATINGSMaster Card$321.82551905060001$321.82
Kennesaw5/14/20192019 CASH KENNESAWVisa$281.59551905140007$281.59
Kennesaw5/15/20192019 CASH KENNESAWVisa 551905150006$58.29
Kennesaw5/15/20192019 CASH KENNESAWVisa$411.27551905150012$352.98
Kennesaw5/16/20192019 CASH KENNESAWVisa$136.21551905160005$136.21
Kennesaw5/23/20192019 CASH KENNESAWVisa$154.74551905230003$154.74
Kennesaw5/24/20192019 CASH KENNESAWVisa 551905240006$529.47
Kennesaw5/24/20192019 CASH KENNESAWVisa$618.50551905240007$89.03
Kennesaw5/28/20192019 CASH KENNESAWMaster Card$437.23551905280006$437.23
Kennesaw5/29/20192019 CASH KENNESAWMaster Card$335.23551905290002$335.23
Kennesaw5/29/20192019 CASH KENNESAWVisa$719.38551905290005$719.38

@Jon-W ,

 

And do records sorted by dates in ascending order and when by card type? Or for the same date records could be like

Visa

MasterCard

Visa

MasterCard

 

 

@Sergei Baklan 

 

They are sorted first by date, then by card type.

@Jon-W 

When it could be like in column I in Sheet2 attached

image.png

=IF(($B1=$B2)*($D1=$D2),"",SUMIFS($G:$G,$B:$B,$B1,$D:$D,$D1))

Start from row 1 and drag down

@Sergei Baklan 

 

That is EXACTLY what I need, but I'm not an Excel expert, and can't figure out how you got the formula into that whole row. When I use formulas, so far they have been basic. =A1*A2 and then I would copy and paste that formula into all the cells below it. This what I'm coming up with when I try your formula. I will paste here, and then link a copy of the excel file. And thank you so much for your help!!

 

DateCustomerNamePayment SaleNumAmount 
5/1/20192019 CASH BIRMINGHAMCash462471905010002$462.00=IF(($B2=$B3)*($D2=$D3),"",SUMIFS(#REF!,$B2:$B21,$B2,$D2:$D21,$D2))
5/2/2019B & T LABORINGCash$190.30471905020005$190.30 
5/8/20192019 CASH BIRMINGHAMCash93.5471905080006$93.50 
5/9/20192019 CASH BIRMINGHAMCash27.5471905090007$27.50 
5/13/20192019 CASH BIRMINGHAMCash 471905130002$492.80 
5/13/20192018 CASH BIRMINGHAMCash156.75471905130006$156.75 
5/15/2019WARREN ASPHALT CONSTRUCTIONCash 471905150003$8.79 
5/15/20192018 CASH BIRMINGHAMCash 471905150004$331.91 
5/15/20192018 CASH BIRMINGHAMCash 471905150006$165.54 
5/15/20192018 CASH BIRMINGHAMCash 471905150007$2.75 
5/15/20192019 CASH BIRMINGHAMCash64.89471905150008$64.89 
5/18/2019BIG JOHN'S ASPHALT PAVINGCash13.2471905180002$13.20 
5/21/20192019 CASH BIRMINGHAMCash492.8471905210002$492.80 
5/23/20192019 CASH BIRMINGHAMCash 471905230001$372.89 
5/23/20192019 CASH BIRMINGHAMCash 471905230008$367.40 
5/23/20192019 CASH BIRMINGHAMCash943.8471905230009$943.80 
5/24/20192019 CASH BIRMINGHAMCash 471905240002$243.91 
5/24/20192019 CASH BIRMINGHAMCash722.7471905240008$722.70 
5/25/2019SOUTHERN SEALS AND STRIPESCash724.9471905250002$724.90 
5/31/20192019 CASH BIRMINGHAMCash176471905310005$176.00 

@Jon-W 

 

In your case formula will be like

=IF(($A2=$A3)*($C2=$C3),"",SUMIFS($F$2:$F2,$A$2:$A2,$A2,$C$2:$C2,$C2))

Be careful which columns to take for the calculation and with absolute / relative references. 

Condition parameter in IF checks if the date AND payment method are the same in the current and next row. If so then empty string. If no, then SUMIFS calculates sum of all payments from first to current row for which the date and payment method are are the same as for current row. 

@Sergei Baklan 

 

You are a life saver!! I have one more snag, and probably something I should have mentioned earlier. In this sheet, there are multiple locations, which might have transactions on the same day for the same form of payment. I have 4 locations, the formula you gave works perfect for the first store, but on the second store, it starts to add the totals from the first store.

This is your formula

=IF(($B1=$B2)*($D1=$D2),"",SUMIFS($G:$G,$B:$B,$B1,$D:$D,$D1))

 

This is your formula, tweaked for my sheet, that does work on the different categories for my first store

=IF(($B2=$B3)*($D2=$D3),"",SUMIFS($G$2:$G2,$B$2:$B2,$B2,$D$2:$D2,$D2))

 

This is what I came up with when I tried to add a 3rd condition

=IF(($B2=$B3)*($D2=$D3)*($A2=$A3),"",SUMIFS($G$2:$G2,$B$2:$B2,$B2,$D$2:$D2,$D2))

 

That still worked for the first location, but then added the daily total from the store above.

 

Once again, I appreciate the help so much!!

@Sergei Baklan 

 

Any thoughts? You have been such a help so far!!

@Jon-W 

 

Sorry, I missed your question. That could be

=IF($A2="","",IF(($B2=$B3)*($D2=$D3)*($A2=$A3),"",SUMIFS($G$2:$G2,$B$2:$B2,$B2,$D$2:$D2,$D2,$A$2:$A2,$A2,$A$2:$A2,"<>")))

in cell E2 and drag it down till end of the range over all locations.

@Sergei Baklan 

 

You are THE BEST!! Thank you so much for your help!!

@Jon-W 

 

You are welcome, glad to help