Help with Array Function

  • Thread starter Thread starter Gos-C
  • Start date Start date
G

Gos-C

Hi Aladin,

It appears to be counting all appearances of each name. If there ar
two names, only the second name should be counted.

Thank for such quick response
 
=SUMPRODUCT(($A$1:$A$5=D1)+ISNUMBER(SEARCH(D1,REPLACE($A$1:$A$5&"/",1,SEARCH("/",$A$1:$A$5&"/"),""))),--($B$1:$B$5="Red"),--($C$1:$C$5>"31-Dec-03"+0),--($C$1:$C$5<"1-Sep-04"+0))
 
You can actually omit the &"/" bits...

=SUMPRODUCT(($A$1:$A$5=D1)+ISNUMBER(SEARCH(D1,REPLACE($A$1:$A$5,1,SEARCH("/",$A$1:$A$5),""))),--($B$1:$B$5="Red"),--($C$1:$C$5>"31-Dec-03"+0),--($C$1:$C$5<"1-Sep-04"+0))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif Help 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Array-friendly functions 1
Inserting blank rows for missing data in order to transpose 3
using CountIF function or Array? 3
counting entries 4
COUNTIF across sheets in columns 1
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4

Back
Top