sumif statement

  • Thread starter Thread starter JR573PUTT
  • Start date Start date
J

JR573PUTT

I am trying to reference a detail sheet to a summary sheet:

detail sheet
a b
number occurence
4 7
5 6


summary sheet:

a b c d e
4 6 7 10 1

I want a formula on the summary sheet to look up the occurence of 4,
and return a value of 7 for the number 4.

I was trying some sumif formulas with no successs
 
Is the number 4 only likely to occur once in your detail sheet? If so,
you can use the VLOOKUP( ) function in the summary sheet to look for a
match in the detail sheet and return a corresponding value from the
same row. I'm not sure, though, what your example summary sheet is
meant to represent, or how the letters are related to the detail sheet.
If you can come back with some further details then i will be able to
elaborate on my suggestion.

Pete
 
Why does 4 return 7, and 5 return 6?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Bob,

We sell 4 - 7 times during a day, so we want to now how many times we
sale 4 items to one customer, hope that helps.

Also the vlookup would not work because the left column has to be in
numeric ascending order, and this worksheet would not be that way.

So I figured it out on my own using the index match function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top