Sum specific col if rows contain same info
Closed
Shantele
-
May 27, 2010 at 10:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 04:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 04:53 PM
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?
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?
Related:
- Sum specific col if rows contain same info
- How to find specific words on a page - Guide
- Potplayer hide info - Guide
- Radio info code - Guide
- Everest system info - Download - Diagnosis and monitoring
- Crystal disk info - Download - Diagnosis and monitoring
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 27, 2010 at 04:53 PM
May 27, 2010 at 04:53 PM
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.
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.