Sorry, i'm new to this. I hope i'm posting on the right site. I have tried several things and my SUMIF formula is not working. Basically i'll explain what i'm trying to do as briefly as I can.
I have a list of fellows that are given a stipend of $500 each to spend for one whole year. I keep track of this on an excel spreadsheet, in one column i have the name, next column the amount they spent, next column the description (not important) and finally i designate the last column with PDF(for their stipend) in this column you will only see two words either PDF or DEPT. In other words if the expense isn't coming out of their stipend then we designate it with the word dept. What i need to do is calculate how much each fellow has spent of their pdf(stipend amount) excluding anything in the PDF column that is worded dept.
I need something like Jane $190.00 PDF (this will be calculated) if it said Jane $510 DEPT. I cannot include this.
I was using this formula =SUMIF(Fellows!A:A,"Jane",Fellows!B:B) which works great because it tells me how much each fellow spent but it gives me their total pdf and dept expenses combined. I only want to see their pdf expenses. Few things worth mentioning, Columns A-Fellows, Amount-B, etc...and Fellows is the name of the worksheet. One more thing, a sample is below but in one year each fellow will appear multiple times, in other words, Jane might appear ten times in one year with 10 different types of expenses that are either expensed to her PDF or the dept. I only need to know how much pdf expenses Jane had in one year.
Fellow AMOUNT DESCRIPTION PDF
Jane 190.00 Book PDF
Joe 53.33 Paper DEPT
Lucy 50.00 Book DEPT
Chad 93.60 Coffee PDF
I hope this makes sense.