Counting number of cells that match name AND number
 

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

Counting number of cells that match name AND number
 

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

Counting number of cells that match name AND number
 

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

Counting number of cells that match name AND number
 

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

Counting number of cells that match name AND number
 

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