Counting number of cells that match name AND number

[Ronster]

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

 

[Mike H]

Maybe

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

Mike

 

[Mike H]

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

 

[Ronster]

Thanks very much, that did the job perfectly.

Ronnie

 

[Mike H]

Glad I could help

Thanks very much, that did the job perfectly.

Ronnie