Understanding parts of a formula

[Randomhero180]

I saw this formula as I was browsing for an answer.

SUMPRODUCT(--(L3:L5000=1),--(C3:C5000="Base"),--(MONTH(R3:R5000)=MONTH(TODAY())-1))

what do the "--" mean?

Thanks

RH

 

[Robert Mika]

Sum values in ranges L,C and R when condtions are met:
L3:L5000= is equal to 1
C3:C5000= is eqaul to "Base"
(MONTH(R3:R5000)=MONTH(TODAY())-1)) = month in this range is equal to the last month (MONTH(TODAY())-1))= to August or 8)

 

[Randomhero180]

just curious why this wont work, I get a #VALUE!

=SUMPRODUCT(--ISNUMBER(MATCH(Sheet1!B19:E12678,{"Estimate Approved","Product Ordered","Product Staged","Photography Complete"},0)),--(Sheet1!V19:V12678="COP"),--(MONTH(Sheet1!H19:H12678)=MONTH(TODAY())))

Thanks!

 

[VoG]

This may help http://www.mrexcel.com/forum/showpost.php?p=337954&postcount=8

I see that in your other thread you seemed to have resolved this by using * as the coercer.

 

[rafaelspeixoto]

take a look if this is what you were looking for:

This is if you are looking for col B equal to any of the values you placed:

=SUMPRODUCT(--(Sheet1!B19:E12678="Estimate Approved")+--(Sheet1!B19:E12678="Product Ordered")+--(Sheet1!B19:E12678="Product Staged")+--(Sheet1!B19:E12678="Photography Complete"),--(Sheet1!V19:V12678="COP"),--(MONTH(Sheet1!H19:H12678)=MONTH(TODAY())))


To learn more about someproduct: http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Randomhero180]

Thanks all for the input!

and yes VoG I did get it to work, I was just trying to gain some more insight into different aspects of excel, seems I am going to start using it a lot more.

 

[Robert Mika]

Thanks all for the input!

and yes VoG I did get it to work, I was just trying to gain some more insight into different aspects of excel, seems I am going to start using it a lot more.

You are welcome!