Hi,

I need to find a way to count how many times in my worksheet there is a
match between a name and a number.
example -

Date Time Organisation Opportunity Size Allocated To Source


7th July 10am ******** 500 Sheelagh Goldmine


So for example, how would i count every time the Opportunity size column (D)
matches 500 AND the Allocated to Column(E) matches Sheelagh?

Would this also work with words ie, instead of "500" could i put "Enterprise"?


And finally, as if that wasnt enough...

My main sheet is named Tracker, and the sheet where i want to count the data
is called Breakdown. - is it possible to link from the breakdown sheet to get
the data?

Thanks

Ronnie

Maybe

=SUMPRODUCT((D21000=500)*(E2:E1000="Sheelagh"))

Mike

"Ronster" wrote:

> Hi,
>
> I need to find a way to count how many times in my worksheet there is a
> match between a name and a number.
> example -
>
> Date Time Organisation Opportunity Size Allocated To Source
>
>
> 7th July 10am ******** 500 Sheelagh Goldmine
>
>
> So for example, how would i count every time the Opportunity size column (D)
> matches 500 AND the Allocated to Column(E) matches Sheelagh?
>
> Would this also work with words ie, instead of "500" could i put "Enterprise"?
>
>
> And finally, as if that wasnt enough...
>
> My main sheet is named Tracker, and the sheet where i want to count the data
> is called Breakdown. - is it possible to link from the breakdown sheet to get
> the data?
>
> Thanks
>
> Ronnie

Hi,

I missed the other 2 parts of your queestion and I think this answers both

=SUMPRODUCT((Breakdown!D21000="Enterprise")*(Breakdown!E2:E1000="Sheelagh"))

Note that because "Enterprise" is now text it's in quotes ""

Mike

"Mike H" wrote:

> Maybe
>
> =SUMPRODUCT((D21000=500)*(E2:E1000="Sheelagh"))
>
> Mike
>
> "Ronster" wrote:
>
> > Hi,
> >
> > I need to find a way to count how many times in my worksheet there is a
> > match between a name and a number.
> > example -
> >
> > Date Time Organisation Opportunity Size Allocated To Source
> >
> >
> > 7th July 10am ******** 500 Sheelagh Goldmine
> >
> >
> > So for example, how would i count every time the Opportunity size column (D)
> > matches 500 AND the Allocated to Column(E) matches Sheelagh?
> >
> > Would this also work with words ie, instead of "500" could i put "Enterprise"?
> >
> >
> > And finally, as if that wasnt enough...
> >
> > My main sheet is named Tracker, and the sheet where i want to count the data
> > is called Breakdown. - is it possible to link from the breakdown sheet to get
> > the data?
> >
> > Thanks
> >
> > Ronnie

Thanks very much, that did the job perfectly.

Ronnie



"Mike H" wrote:

> Hi,
>
> I missed the other 2 parts of your queestion and I think this answers both
>
> =SUMPRODUCT((Breakdown!D21000="Enterprise")*(Breakdown!E2:E1000="Sheelagh"))
>
> Note that because "Enterprise" is now text it's in quotes ""
>
> Mike
>
> "Mike H" wrote:
>
> > Maybe
> >
> > =SUMPRODUCT((D21000=500)*(E2:E1000="Sheelagh"))
> >
> > Mike
> >
> > "Ronster" wrote:
> >
> > > Hi,
> > >
> > > I need to find a way to count how many times in my worksheet there is a
> > > match between a name and a number.
> > > example -
> > >
> > > Date Time Organisation Opportunity Size Allocated To Source
> > >
> > >
> > > 7th July 10am ******** 500 Sheelagh Goldmine
> > >
> > >
> > > So for example, how would i count every time the Opportunity size column (D)
> > > matches 500 AND the Allocated to Column(E) matches Sheelagh?
> > >
> > > Would this also work with words ie, instead of "500" could i put "Enterprise"?
> > >
> > >
> > > And finally, as if that wasnt enough...
> > >
> > > My main sheet is named Tracker, and the sheet where i want to count the data
> > > is called Breakdown. - is it possible to link from the breakdown sheet to get
> > > the data?
> > >
> > > Thanks
> > >
> > > Ronnie

Glad I could help

"Ronster" wrote:

> Thanks very much, that did the job perfectly.
>
> Ronnie
>
>
>
> "Mike H" wrote:
>
> > Hi,
> >
> > I missed the other 2 parts of your queestion and I think this answers both
> >
> > =SUMPRODUCT((Breakdown!D21000="Enterprise")*(Breakdown!E2:E1000="Sheelagh"))
> >
> > Note that because "Enterprise" is now text it's in quotes ""
> >
> > Mike
> >
> > "Mike H" wrote:
> >
> > > Maybe
> > >
> > > =SUMPRODUCT((D21000=500)*(E2:E1000="Sheelagh"))
> > >
> > > Mike
> > >
> > > "Ronster" wrote:
> > >
> > > > Hi,
> > > >
> > > > I need to find a way to count how many times in my worksheet there is a
> > > > match between a name and a number.
> > > > example -
> > > >
> > > > Date Time Organisation Opportunity Size Allocated To Source
> > > >
> > > >
> > > > 7th July 10am ******** 500 Sheelagh Goldmine
> > > >
> > > >
> > > > So for example, how would i count every time the Opportunity size column (D)
> > > > matches 500 AND the Allocated to Column(E) matches Sheelagh?
> > > >
> > > > Would this also work with words ie, instead of "500" could i put "Enterprise"?
> > > >
> > > >
> > > > And finally, as if that wasnt enough...
> > > >
> > > > My main sheet is named Tracker, and the sheet where i want to count the data
> > > > is called Breakdown. - is it possible to link from the breakdown sheet to get
> > > > the data?
> > > >
> > > > Thanks
> > > >
> > > > Ronnie