zookeeperbobbie
Board Regular
- Joined
- Feb 9, 2005
- Messages
- 117
Hello, I have a formula that I am stuck with
I need to create a formula that will give me the total # of pcs per vendor in a date range that I can specify.
So far this is the formula that I am using:
=SUMIF(MAIN!1:65536,C3,MAIN!K:K)
c3 is where i am typing in the vendor name column k is the row where the # pcs are entered
I tried using this formula but it will not work on sumif-If keeps changing the +0 to *0 and giving me a value error. It did work on a sumproduct that I tried to do...
=SUMPRODUCT((MAIN!$A$5:$A$310=$C$3)+0,(MAIN!F$5:F$310=$B15)+0,(MAIN!$C$5:$C$310>=$E$3)+0,(MAIN!$C$5:$C$310<=$E$5)+0)
(e3 is the start date range and e5 is the end date range- C5-310 IS Where that date is entered in my main database)
Any suggestions?
Thanks
I need to create a formula that will give me the total # of pcs per vendor in a date range that I can specify.
So far this is the formula that I am using:
=SUMIF(MAIN!1:65536,C3,MAIN!K:K)
c3 is where i am typing in the vendor name column k is the row where the # pcs are entered
I tried using this formula but it will not work on sumif-If keeps changing the +0 to *0 and giving me a value error. It did work on a sumproduct that I tried to do...
=SUMPRODUCT((MAIN!$A$5:$A$310=$C$3)+0,(MAIN!F$5:F$310=$B15)+0,(MAIN!$C$5:$C$310>=$E$3)+0,(MAIN!$C$5:$C$310<=$E$5)+0)
(e3 is the start date range and e5 is the end date range- C5-310 IS Where that date is entered in my main database)
Any suggestions?
Thanks