SOLVED

SUMIF function

Copper Contributor

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 (Copper Contributor)
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.

 

 

1 best response

Accepted Solutions
best response confirmed by kcted (Copper Contributor)
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.

 

 

View solution in original post