Hi guys, looks like a nice forum you have here.
I've started making a record of all the purchases every month that m
kitchen makes. I've set every supplier to an ID code (001,002,003 et
etc) and i record this code in the same row as each purchase amount. S
for a month, i have a list of purchases, with totals excluding vat, va
and then a total inclusive of vat. At the end of the month i can simpl
sum the last column to see how much i've spent at the end of ever
month.
However i'd like to see how much i've spent with each supplier for th
month. This i'm struggling a bit with. I understand that i need t
search for a supplier ID, where it is apparent in the ID column i am t
add the total for that purchase to the running total.
Its very similar to the FAQ problem and answer that reads
___________________________________________________________
Problem:
Counting the number of \"red\" items which cost less than $1000.
Solution:
Using the SUMPRODUCT function to count the number of items meeting th
above criteria, as follows:
=SUMPRODUCT((C2:C6<1000)*(B2:B6="red"))
Item______Item\'s Color____Price
Jacket____red_____________$500
Jeans_____blue____________$200
T-Shirt___red_____________$1,200
Shoes_____black___________$800
Socks_____red_____________$700
Result 2
________________________________________________________________
Except here i'd want to be finding the total spent for every item tha
is red, (in this case i'd want my result to be $2,400) not the numbe
of items that meet the given criteria.
Any help is very much appreciated. Thanks
--
ren_juanj
-----------------------------------------------------------------------
ren_juanjo's Profile:
http://www.excelforum.com/member.php...fo&userid=3715
View this thread:
http://www.excelforum.com/showthread.php?threadid=56875
Similar Threads
