PayPal Excel Sheet- Adding Net column for Specific Words

[Stevens]

-----------------------------------------------------------------------
A poll associated with this post was created, to vote and see th
results, please visit http://www.excelforum.com/showthread.php?threadid=52295
-----------------------------------------------------------------------
Question: Did this help

- Yeah, or at least some
- Nope, not at all
-----------------------------------------------------------------------

PayPal Excel Sheet- Adding Net column for Specific Words

I have my PayPal history .csv and need to break it down w/out tearin
it apart and deleteing parts. I understand Excel pretty well, but
am not too familiar w/the functions beyond the basics. I do a bunch o
eBay sales and need to separate the income for items sold that belonge
to me and those that belonged to my friend.
For starters, I need to add the amount of Net income, column I, bu
only the "eBay Payment Received," from column E. Once I know this
I'll move on to breaking down the items sold between my friend's incom
and my own.

I tried -=SUMPRODUCT((I2:I231="eBay Payment Received"))- from anothe
post, but to no avail.

I wish I could just setup rules like in Outlook. I always like to mak
things difficult.

Any help would be greatly appreciated

 

[Dave Peterson]

=sumif(e2:e231,"ebay payment received",i2:i231)

May work for you.

 

[Stevens]

-----------------------------------------------------------------------
A poll associated with this post was created, to vote and see th
results, please visit http://www.excelforum.com/showthread.php?threadid=52295
-----------------------------------------------------------------------
Question: Did this help

- Yeah, or at least some
- Nope, not at all
-----------------------------------------------------------------------

THAT WORKS.
I actually figured it out shortly before your reply.

Thanks so much for the help