I have a spreadsheet with multiple sheets. I'm trying to create a formula on Sheet 1 that pulls information from Sheet 3.

I'm trying to create a forumla to add the amount of Windows 2008 servers (column B) that are marked as production (column L)

=SUMPRODUCT('Sheet 3'!B2:B799,"Windows 2008")*('Sheet 3'!L2:L799,"Production"))

Any help would be appreciated.

Thanks.