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
Netscur Posts 21 Registration date Thursday July 23, 2009 Status Member Last seen April 6, 2012 - Jun 17, 2010 at 09:31 AM
Related:
- Help! Need Formula!
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 17, 2010 at 09:28 AM
Jun 17, 2010 at 09:28 AM
Use SUMIF
=SUMIF(crieteia range, condition to match, Sum range)
=SUMIF(crieteia range, condition to match, Sum range)
Netscur
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
Jun 17, 2010 at 09:31 AM
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.
=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.
