sumproduct

[Jerry Kinder]

I have this formula in use and it works perfectly. I now need to change the
sum area from H4:h484 to H4:J484 and now it only give me 0. How do I get it
to sum the larger area??

=IF($B3<=0,"",SUMPRODUCT((SVEexp!$B$4:$B$484=Summary!$B3)*(SVEexp!$C$4:$C$48
4=Summary!$C3),SVEexp!$H$4:$H$484))

Thank you, Jerry

 

[Guest]

Hi

You need to make sure that all of the ranges in SUMPRODUCT are the same
size. If you alter one of the ranges, you'll have to alter the others
accordingly.

Hope this helps.
Andy.

 

[Jerry Kinder]

I changed the end range to
=IF($B3<=0,"",SUMPRODUCT((SVEexp!$B$4:$B$484=Summary!$B3)*(SVEexp!$C$4:$C$48
4=Summary!$C3),SVEexp!$H$4:$J$484)) and got #Value error. The only change
was the end range where the numbers are.

 

[Guest]

But like I said, all of the ranges within a SUMPRODUCT must be the same
size. You've doubled the size of the last range so you'll have to do the
same with the others.
Post some sample data if I'm not understanding you correctly.

Andy.

 

[Jerry Kinder]

Hi,
I hope this helps clear up what I am asking.
This is the data sheet all:
B C F G
H
Checks Cash
Visa
Office Phone 24.90
Wages Sue 200.00
Office Misc. 37.34
Wages Bill 200.00
Office Supplies
12.96

Where the formula is "the summary sheet"
B C D
Office Phone t he formula for totals
Office Misc.
Offcie Supplies
Wages Sue
Wages Bill

 

[Bob Phillips]

Jerry,

Try

=IF($B3<=0,"",SUMPRODUCT((SVEexp!$B$4:$B$484=Summary!$B3)*(SVEexp!$C$4:$C$48
4=Summary!$C3)*(SVEexp!$H$4:$J$484))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Jerry Kinder]

YES!!!! it is PERFECT.

Thank you, Thank you, Thank you, Thank you

 

[Bob Phillips]

It's a pleasure (4 times) <vbg>

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)