On Jul 24, 9:11 pm, ST <sdst...@sbcglobal.net> wrote: On 7/24/08 7:40 PM, in article 32c3859b-fda1-4521-ae73-121692716...@z26g2000pre.googlegroups.com, "Kurgan Gringioni" <kgringi...@hotmail.com> wrote: On Jul 24, 3:57 pm, Keith <nos...@nospam.com> wrote: Evans has turned out to be the Erik Zabel of GC Dumbass - He might still win. Sastre, Schleck
"Robin" <miracleweb@gmail.com> wrote in message news:06d4a921-fda1-4055-9202-a29676e408b0@w5g2000prd.googlegroups.com... On Jun 8, 4:05 pm, "Carrie" <starchild1...@yahoo.com> wrote: "Robin" <miracle...@gmail.com> wrote in message news:ec9eb56e-9228-4df8-a288-f725786b0cc4@z16g2000prn.googlegroups.com... On Jun 8, 3:13 pm, Deborah <debo...@dumpetydump.com> wrote:
<vivapadrepio@aol.com> wrote in message news:ded303b0-fda1-4d6b-a42f-b892142f5f27@f36g2000hsa.googlegroups.com... Warning To The Rich. Come now, you rich, weep and wail over your impending miseries. Your wealth has rotted away, your clothes have become moth-eaten, your gold and silver have corroded, and that corrosion will be a testimony against you; it will devour your flesh
I didn't see where you kept the xyz stuff: =sumproduct(--(revenue!$a$9:$a$3800="xyz"), --(text(revenue!$v$9:$v$3800,"yyyymm")=text($n$9,"yyyymm")), revenue!$ad$9:$ad$3800) The --(revenue!$ad$9:$ad$3800) portion will cause an error if there are non-numeric entries in that range. Adjust the ranges to match--but you can't use whole columns (except in xl2007).
try this =SUMPRODUCT(--(MONTH(Revenue!$V$9:$V$3800)=MONTH($N$9)),--(YEAR(Revenue!$V$9:$V$3800)=YEAR($N$9)),--(Revenue!$D$9:$D$3800=B26),Revenue!$AD$9:$AD$3800) or =SUMPRODUCT((MONTH(Revenue!$V$9:$V$3800)=MONTH($N$9))*(YEAR(Revenue!$V$9:$V$3800)=YEAR($N$9))*(Revenue!$D$9:$D$3800=B26)*Revenue!$AD$9:$AD$3800)--Don GuillettMicrosoft MVP ExcelSalesAid Softwaredguillett1@austin.rr.com"baseballkyle" <baseballkyle@gmail
