sum a range only if certain text in another Closed

Question

Hello,
I need a formula to sum the values in a range of cells but only for the cells that have a specific text in a completely different range of cells.

For example,

sum the values for H8:I12
but only if the text in C8:C12 EQUALS "CRM"

I have 5 different text values in order of importance:
LFIP
FIP
ERM
CRM
CIP
Any help would be of great appreciation

X

Network Access Message: The page cannot be displayed

Explanation: The request timed out before the page could be retrieved.

Try the following:

Refresh page: Search for the page again by clicking the Refresh button. The timeout may have occurred due to Internet congestion.
Check spelling: Check that you typed the Web page address correctly. The address may have been mistyped.
Contact website: You may want to contact the website administrator to make sure the Web page still exists. You can do this by using the e-mail address or phone number listed on the website home page.

If you are still not able to view the requested page, try contacting your administrator or Helpdesk.

Technical Information (for support personnel)

Error Code 10060: Connection timeout
Background: The gateway could not receive a timely response from the website you are trying to access. This might indicate that the network is congested, or that the website is experiencing technical difficulties.
Date: 8/27/2009 1:27:08 PM [GMT]
Server: bp1pbupx001.bp1.ad.bp.com
Source: Firewall

venkat1926 · Accepted Answer

your information is not complete 
I assume the five text strings are in H8 to H12 
and in I6 to I12 there are some numbers

now use this formula 

=SUM(IF(H8:H12="CRM",I8:I12))
This is ana rray formula so INVOKE THIS FORMULA BY HITTING 
CONTROL+SHIFT+ENTER.

Sum a range only if certain text in another

1 response

Similar discussions

Subscribe To Our Newsletter!