Generating formula for multiple columns

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.

Hello,

I just need a number.

I believe that you are simply missing an open parenthesis and equal signs (instead of commas). That is,

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

As Ali said, I would use COUNTIFS instead of SUMPRODUCT.

That would look like this:

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

Works like a charm. Thanks.