Sum formula

wonderd

Board Regular
Joined
Oct 20, 2013
Messages
168
Hey everyone I have a simple formula I'm having trouble getting to work.

Screenshot of the formula is here https://www.screencast.com/t/mp1lIes0hSlq

I only want to add cells with negative numbers if it has the word paypal or bkcd however its returning a 0 value

Correct output should be -4
 
Last edited:

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Re: Help with sum formula

You may need to put the values and words in separate columns.
 
Upvote 0
Re: Help with sum formula

I can do that. If thats needed, what would the formula then be?
 
Upvote 0
Re: Help with sum formula

It would help to use the Jeannie to attach html of desired area.
 
Upvote 0
Re: Help with sum formula

Rule #13 :
We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
- Post the details of your question on our forum. Do NOT simply post a link/re-direct to the question in another forum with no details posted here.
- Make it clear that you have cross-posted and provide links to the cross-posts.
Cross-posted questions that do not comply may be deleted or locked. For a discussion on the issues with cross-posting, see this link: Excelguru Help Site - A message to forum cross posters
 
Last edited:
Upvote 0
Re: Help with sum formula

I have been completely ignored on the other site and asked politely to have the post and my account removed. I do not know what to do.

I am very sorry to offend anyone.
 
Upvote 0
Re: Help with sum formula

Could you provide several examples?

Are the numbers in text cells always negative?
Are all numbers in text cells to be included?
What total do you require?
Are the numbers single digits?


Excel 2010
H
35
4-2 paypal
5-2 bkcd
63
74
9b
Cell Formulas
RangeFormula
H7{=SUM(H3:H6)+SUM(IF(ISTEXT(H3:H6),LEFT(H3:H6,2)+0))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0
Re: Help with sum formula

After Text to Columns


Excel 2010
AB
28After Text to Columns
295
30-2paypal
31-2bkcd
323
33-4
9b
Cell Formulas
RangeFormula
B33=SUM(SUMIF(B29:B32,{"paypal","bkcd"},A29:A32))
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,296
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top