sumif statement

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)

"JR573PUTT" <JR573PUTT.23ci3m_1140132300.4805@excelforum-nospam.com> wrote
in message news:JR573PUTT.23ci3m_1140132300.4805@excelforum-nospam.com...
>
> 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
>
>
> --
> JR573PUTT
> ------------------------------------------------------------------------
> JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
> View this thread: http://www.excelforum.com/showthread...hreadid=513424
>

I dunno!

Pete

use the formula "countif", set the criteria "4"

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.