Help! Need Formula!

Closed
julez - Jun 17, 2010 at 09:03 AM
Netscur Posts 21 Registration date Thursday July 23, 2009 Status Member Last seen April 6, 2012 - Jun 17, 2010 at 09:31 AM
Hello,



Hello,
I'm trying to find a formula to sum several cells if a certain cell = text. ex: if cell a1=mda then sum a2.

Does this make sense?

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 17, 2010 at 09:28 AM
Use SUMIF

=SUMIF(crieteia range, condition to match, Sum range)
0
Netscur Posts 21 Registration date Thursday July 23, 2009 Status Member Last seen April 6, 2012
Jun 17, 2010 at 09:31 AM
I am not completely clear on your request and data format, but try a SUMIF formula.

=SUMIF(A:A,"MDA",B:B)

The example above has your identifier data range set at column A. If any cells in that column = "MDA" the formula will add all the corresponding quantities found in column B.
0