Pull data from 2 sheets into one
I am trying to make a table in one sheet, with counts of items coming from 2 other sheets when they meet certain criteria. I am using COUNTIF.
When entering the formula, I can only refer to sheet1. If I want to refer to sheet 2 in some of the rows, the whole column (all rows) will then be changed to the range in sheet 2.
thank you in advance
Help Article Resources
Check out the Formula Handbook template!