Excel formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with a formula. This is my problem:

customer penalties charged
abc 3
abc 5
abc 1
def 6
def 10
def 9
ghi 1
ghi 2
ghi 7

I am creating a new chart to figuring out the info below:

customer net $ gross $ penalty refunds
abc
def
ghi

I have the net $ column formula figured out however I need help with the
gross dollars. I am trying to use a sumif, than, otherwise this formula but
it is not working. I need the information to pull from the info at the top.
This is what I have been working with: =sumif(a2:a9,p2,b2:b9,>0)

Any suggestions?
 
This newsgroup is for questions about Access, the database product that's
part of Office Professional.

I'd suggest reposting your question to a newsgroup related to Excel.
 
Back
Top