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.
 
Back
Top