Trying to add informtion from two sheets

Connie Cochran

I have two sheets with the same column and I am trying to write a formula that says to only count the cells that say "Red" in them. I got it to work with a single sheet but I need the total to be from two sheets, the current and the archived.

This is how I wrote it but its not working

=COUNTIF([REPORTING Screeners onsite]:[REPORTING Screeners onsite], "Red")+(Count({Biometric Testing Request Form Range 1}:{Biometric Testing Request Form Range 1}, "Red"))

Help?

Shimanta Roy

Hi Connie, try the following formula:

=COUNTIF([REPORTING Screeners onsite]:[REPORTING Screeners onsite], "Red")+COUNTIF({Biometric Testing Request Form Range 1}:{Biometric Testing Request Form Range 1}, "Red")

I am assuming that you are referring the range, {Biometric Testing Request Form Range 1}:{Biometric Testing Request Form Range 1}, is where the column contains the Red values in the other sheet.