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
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 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
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.
0