Need help with a formula

Kyle Orrell

I'm trying to write a formula to capture the times a data point occurs in two different sheets. I've written a formula =COUNTIFS({range 1}, "Early", {range 2}, "Early"). the formula is not capturing correctly. Anyone know what I'm doing wrong

rrenee

Hi Kyle,

I don't think COUNTIFS can have criteria from two different sheets, maybe try adding two countif statements together (one for each sheet) like this:

=COUNTIF({Range 1}, "Early") + COUNTIF({Range 2},"Early")

Typically COUNTIFS is used for filtering from a single sheet by multiple criteria, but in this case there is just one criteria in two separate sheets.

rrenee

Hi Kyle,

I don't think COUNTIFS can have criteria from two different sheets, maybe try adding two countif statements together (one for each sheet) like this:

=COUNTIF({Range 1}, "Early") + COUNTIF({Range 2},"Early")

Typically COUNTIFS is used for filtering from a single sheet by multiple criteria, but in this case there is just one criteria in two separate sheets.