SOLVED

SUMIF function

%3CLINGO-SUB%20id%3D%22lingo-sub-2103005%22%20slang%3D%22en-US%22%3ESUMIF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103005%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20sum%20the%20values%20in%20column%20J%2C%20based%20off%20the%20value%20in%20column%20E%20with%20a%20large%20amount%20of%20data%20(over%2020k%20rows)%3F%20Column%20E%20will%20have%20anywhere%20from%201%20to%2012%20rows%20of%20repeating%20values.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2103005%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2103228%22%20slang%3D%22de-DE%22%3ESubject%3A%20SUMIF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103228%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F944992%22%20target%3D%22_blank%22%3E%40kcted%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20provides%20multiple%20techniques%20that%20you%20can%20use%20to%20count%20cells%2C%20rows%2C%20or%20columns%20of%20data.%20To%20help%20you%20make%20the%20best%20choice%2C%20this%20article%20provides%20a%20comprehensive%20summary%20of%20methods%2C%20a%20downloadable%20workbook%20with%20interactive%20examples%2C%20and%20links%20to%20related%20topics%20for%20further%20understanding.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWays%20to%20count%20values%20in%20a%20worksheet%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fways-to-count-values-in-a-worksheet-81335b1b-d5e8-4f42-ae72-245b948c45bd%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fways-to-count-values-in-a-worksheet-81335b1b-d5e8-4f42-ae72-245b948c45bd%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20a%20example%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

Is there a way to sum the values in column J, based off the value in column E with a large amount of data (over 20k rows)? Column E will have anywhere from 1 to 12 rows of repeating values. 

1 Reply
Best Response confirmed by kcted (Occasional Visitor)
Solution

@kcted 

 

Excel provides multiple techniques that you can use to count cells, rows, or columns of data. To help you make the best choice, this article provides a comprehensive summary of methods, a downloadable workbook with interactive examples, and links to related topics for further understanding.

 

Ways to count values in a worksheet

https://support.microsoft.com/en-us/office/ways-to-count-values-in-a-worksheet-81335b1b-d5e8-4f42-ae...

 

With a example spreadsheet.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.