1. ## sumproduct (Excel 2000)

Can anybody help me out with my formulae in sheet 'recap-1' and comes out with total amount for each group of Months?

-indra-

2. ## Re: sumproduct (Excel 2000)

In D3:

=SUMPRODUCT((IDSB34!\$A\$3:\$A\$355=\$B3)*(IDSB34!\$E\$3: \$E\$355=D\$2),IDSB34!\$H\$3:\$H\$355+IDSB34!\$I\$3:\$I\$355+ IDSB34!\$J\$3:\$J\$355+IDSB34!\$K\$3:\$K\$355)

and in F3:

=SUMPRODUCT((IDSB34!\$A\$3:\$A\$355=\$B3)*(IDSB34!\$E\$3: \$E\$355=F\$2),IDSB34!\$L\$3:\$L\$355+IDSB34!\$M\$3:\$M\$355+ IDSB34!\$N\$3:\$N\$355+IDSB34!\$O\$3:\$O\$355+IDSB34!\$P\$3: \$P\$355+IDSB34!\$Q\$3:\$Q\$355+IDSB34!\$R\$3:\$R\$355+IDSB3 4!\$S\$3:\$S\$355)

This can be copied to the other cells.

3. ## Re: sumproduct (Excel 2000)

Hi,
<code>=SUMPRODUCT((IDSB34!\$A\$3:\$A\$355=\$B3)*(IDSB34 !\$E\$3:\$E\$355=D\$2)*IDSB34!\$H\$3:\$K\$355)</code> in D3, and
<code>=SUMPRODUCT((IDSB34!\$A\$3:\$A\$355=\$B3)*(IDSB34 !\$E\$3:\$E\$355=F\$2)*IDSB34!\$L\$3:\$S\$355)</code> in F3.
Copy down/across as needed.
HTH

4. ## Re: sumproduct (Excel 2000)

Many thanks, Hans.

cheers,

5. ## Re: sumproduct (Excel 2000)

thanks for * Rory.

-indra-

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•