Help! Need Formula!
Closed
julez
-
17 Jun 2010 à 09:03
Netscur Posts 21 Registration date Thursday 23 July 2009 Status Member Last seen 6 April 2012 - 17 Jun 2010 à 09:31
Netscur Posts 21 Registration date Thursday 23 July 2009 Status Member Last seen 6 April 2012 - 17 Jun 2010 à 09:31
Related:
- Help! Need Formula!
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Jun 2010 à 09:28
17 Jun 2010 à 09:28
Use SUMIF
=SUMIF(crieteia range, condition to match, Sum range)
=SUMIF(crieteia range, condition to match, Sum range)
Netscur
Posts
21
Registration date
Thursday 23 July 2009
Status
Member
Last seen
6 April 2012
17 Jun 2010 à 09:31
17 Jun 2010 à 09:31
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.
