![]() |
|
#1
|
|||
|
|||
|
Trying to build a formula that will return the value of a range of fields if the data in another range of fields is equal to specific text.
For example I want the sum of all fields in range F2:F214 if C2:C214 = "LSP" Can anyone help? Everything I try does not work. |
| Tags |
| excel 2010, formula |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
WHEN formula
|
agent007 | Excel | 5 | 02-06-2014 09:20 PM |
What formula should I use?
|
TotalONE | Excel | 3 | 11-26-2013 01:30 PM |
help with formula?
|
doczilla | Excel | 2 | 09-25-2011 04:14 PM |
PMT Formula
|
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |
If formula
|
sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |