This will work if you expect a result of 42.32%:
=SUMPRODUCT(--(A20=A5:A12),(B5:B12),(C5:C12))/C20



"SanCarlosCyclist" wrote:

I am having a problem using Sumproduct when some of the cells have
null values. I will try to describe the problem. Please let me know
if
you need additional information. Do any of you have any ideas of how
I
can fix that sumproduct to get it to work?

A B C
Row Trend Claims
5 Emergency $0
6 Emergency $0
7 Emergency $0
8 Emergency 81.68% $24,444
9 Emergency 35.00% $164,758
10 Emergency 35.00% $215,237
11 Emergency 22.73% $105,059
12 Emergency 8.46% $53,760

20 Emergency $563,258

My goal is to calculate an aggregate trend for the Emergency Category
excluding those rows that are null trend in cell b20. I tried the
following formula:
SUMPRODUCT((A20=A5:A12)*(A5:A12)*b5:b12)/c20
The result s "#Value"
Do you know how to get this to work?
.