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
|