Sum specific col if rows contain same info

Closed
Shantele - May 27, 2010 at 10:09 AM
rizvisa1
Posts
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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