Sum specific col if rows contain same info

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I would like to add cells in certain columns (for example: a & c) if the data in a certain row (say "8") is the same. I'm sure it's a logical AND or OR in a SUM + IF statement, but the examples I see are not specific to what I need.

Can you help, please?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Have you tired SUMIF ?

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.