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((D2:D1000=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!D2:D1000="Enterprise")*(Bre akdown!E2:E1000="Sheelagh"))

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

Mike

"Mike H" wrote:

Maybe

=SUMPRODUCT((D2:D1000=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!D2:D1000="Enterprise")*(Bre akdown!E2:E1000="Sheelagh"))

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

Mike

"Mike H" wrote:

Maybe

=SUMPRODUCT((D2:D1000=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!D2:D1000="Enterprise")*(Bre akdown!E2:E1000="Sheelagh"))

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

Mike

"Mike H" wrote:

Maybe

=SUMPRODUCT((D2:D1000=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