Excel Statistical Sheets How to extract data from other worksheets

The problem statement is not too clear, but the problem should not be difficult, there is no attachment, it is not good to answer. You can use the array function to deal with it. At least have the style of the table, and then put some data on it, so that people can help you answer.

If it is just based on finding data that meets a condition, use the vlookup function; if you want to find the number of conditions to meet more than one, use the array formula, similar to: = sum(--(worksheet 2!A1:A10="Computer")*(worksheet 2!B1:B10="Extranet")*(worksheet 2!C1:C10=""))

That's it.

Note that the array formula is written to press Ctrl + Shift + Enter, not directly press Enter.