Pull data from 2 sheets into one

Giselef

Hi,

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.

any ideas?

thank you in advance

Paul Newcome

You will need to create a new cross sheet reference instead of editing the existing one.

Paul Newcome

You will need to create a new cross sheet reference instead of editing the existing one.

Giselef

Done !! thank you so much =)

Paul Newcome

Happy to help. 👍️