Prev: answer
Next: Conditional Formatting in Excel 2007
From: wantfit on 22 Apr 2010 16:21
I want to use sumifs to find the results. For range A1:A100, If value in
column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do
I do that?

Thanks
From: Teethless mama on 22 Apr 2010 16:37
=SUMPRODUCT(--(A1:A100=C1:C100),A1:A100)


"wantfit" wrote:

> I want to use sumifs to find the results. For range A1:A100, If value in
> column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do
> I do that?
>
> Thanks
 | 
Pages: 1
Prev: answer
Next: Conditional Formatting in Excel 2007