Formula in Excel SUMPRODUCT & styear

[wilest]

Hi All
I'm trying to find out what this formula does, I don't understand the styear & stmonth & starea. Help will be greatly apreciated.


=SUMPRODUCT(--(styear=Data!AA$14),--(stmonth=Data!AA$12),--(starea='MTD Sales - Sales Teams'!C9),sthl)+SUMPRODUCT(--(stdyear2=Data!AA$14),--(stdmonth2=Data!AA$12),--(stdarea=C9),stdhl)

 

[Robert Mika]

Those are Named Ranges referred to s place(cell,column, row..) in your workbook.Check them under Name Manager.

 

[wilest]

Thank you!

 

[jono19872006]

it could be a named range??

 

[Robert Mika]

Thank you!

You are welcome.