Formula to Exclude but include other same named data

[Knight_Angel_05]

I have a spreadsheet that I have hundreds of columns and about 10 rows. However, I am only looking at Columns A and C for my data. I know what I am looking for. I have tried using SUMPRODUCT. What I want to do is so for instance look for anything with a specific name like Wal-Mart and sum everything that I have for instance spent at Wal-Mart. However, at the same time I also want to exclude anything I have spent at Wal-Mart that is over $1,000.00.

This is what I am using to find everything I have spent at Wal-Mart: =SUMPRODUCT(('Checking Account Balance'!$A$8:$A$1000=$A$3)*'Checking Account Balance'!$C$8:$C$1000) I want to include everything under $1,000 but exclude everything over $1,000. Is there a way to do this with SUMPRODUCT. Or am I needing to include inside of the array for SUMPRODUCT a SUMIF statement?

I have tried this but it returns the total number of times that Wal-mart shows up in my list instead of the total with the exclusions: =SUMPRODUCT(('Checking Account Balance'!$A$8:$A$1000="Wal-Mart")*($C$8:$C$1000<"1000")*($C$8:$C$1000))
I know what totals I need based on the checks and balances that I have built into the spreadsheet, just not able to do this correctly.

[FlameRetired]

Hello Knight_Angel_05. Welcome to the forum.

Remove the quotes from ($C$8:$C$1000<"1000")

Those quotes force the number into text "numbers". Text has a numeric value of 0.

[Knight_Angel_05]

FlameRetired:
When I remove the quotes I get a reported number value of 14 back as I do with the quotes instead of -$886.20 or -$4,448.92
I have -$3,562.72 of Wal-mart expenditures which is 2 purchases (money orders) as well with a total of 12 purchases totaling -$886.20 giving me -$4,448.92 grant total. But I want it to automatically remove the 2 of 14 expenditures totaling -$3,562.72 giving a total of 12 expenditures with a value of -$886.20. I know what I would like it to do, just still befuddling me as to how I should get there the short way instead of the long way of having multiple tables breaking down them individually.

Greatly appreciate the assistance so far! Thank you much.

[AliGW]

Please attach a sample workbook showing the issue.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[Knight_Angel_05]

Here is a Test workbook where I copied all data too.
The data in question is on Tab 2 next to checking account balance tab.

[Fluff13]

How about

Please Login or Register  to view this content.

[Knight_Angel_05]

WOOHOO! That worked. However, I changed the <-1000 to a >-1000 and it gave me the result that I wanted. YAY! Thank you all those who helped with this.

[FlameRetired]

You are welcome. Glad to help. Thank you for the feedback and added rep.

One more thing:

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Fluff13]

Glad to help & thanks for the feedback