I have a table where I want to track the total quantity of items entered by group. Additionally I need to calculate the total by multiplying the item quantity by the rate. Once the group quantity reaches the maximum allowed no more totals will added. I am using the formula:
=[@Max]-SUMIFS([@Qty],[Group],[@Group],[Tally],"<[@Tally]")
Tally = The running count of the items per group.
I am getting at #VALUE! error, but don't know why.
Any suggestions??
Running Count.xlsx
Not sure what you're trying to do with that formula but the sum_range is just a single cell while the criteria ranges are multiples of cells.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
THis, copied down, will give you the totals...
=IF(OR(A2="",COUNTIF($F$2:F2,F2)>1),"",SUMIF($C$2:$C$11,"*"&F2&"*",$B$2:$B$11))
However, I dont see a rate in your sample?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks