Help! DSUM, IFSUM or VLOOKUP

[Mr Marketing]

My 1st post...I have a meeting due tomorrow. I believe DSUM should be the easiest way to do what I'm trying to do?...but I'm getting incorrect data back. Need help!

Have 12 thousand rows of data in a sales price list, which has various tiers of pricing (i.e. tiers 1 - 6). Trying to sum revenue for Tier 1, Tier 2, etc. Getting incorrect results from DSUM, and my meeting is tomorrow, yikes! Assume it's my formula.

Any/all assistance would be greatly appreciated!

Thanks.

[Jacc]

Have you considered pivottable?

[jeffreybrown]

Maybe in K6 copied down...

=INDEX($J$13:$J$18,MATCH(1,IF($C$13:$C$18=C6,IF($H$13:$H$18=I6,1)),0))

IMPORTANT
This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

Note: I did not see a match for Product A and 57.56

[Haseeb Avarakkan]

If you are using $A$5:$J$9 in the criteria, will SUM all the conditions in the range. NOT a single row.

If you are looking to SUM each row, try this in K6,

=DSUM($A$12:$J$18,"Period Revenue",A$5:J6)-SUM(K$5:K5)

Then fill down.

[Mr Marketing]

Haseeb,

You are a scholar and a gentleman--thank you. Plugging the formula into the company data now. It appears to indeed be working, but I'm not out of the woods yet. May need your expertise a little later today. How long will you be around?

Thanks,

Mr. Marketing