|
In response to
"try adding something like *(A2:A2000="fayette") to the condition of your if function -- nm"
by
zork
|
I did this:
Posted by
amanda
Nov 9 '12, 09:51
|
=SUMPRODUCT(('RAW FA2012 VLN'!$O$2:$O$238='RN to BS '!C8)*(MATCH('RAW FA2012 VLN'!$A$2:$A$238&"|"&'RAW FA2012 VLN'!$O$2:$O$238,'RAW FA2012 VLN'!$A$2:$A$238&"|"&'RAW FA2012 VLN'!$O$2:$O$238,0)=ROW('RAW FA2012 VLN'!$A$2:$A$238)-ROW(A2)+1))
not so pretty maybe but it gets the job done.
|
Responses:
|