Using two ranges as ONE RANGE in countifs with conditions. Formula returns an error

**Lifeseeker** · 12-16-2011, 09:28 PM

Hi there,

I have a total of 3 worksheets. The first worksheet shows record details for site A while the 2nd worksheet shows record details for site A as well, but this is more of a supplementary worksheet. The 3rd worksheet is for reporting.

What I would like:

Use a countifs formula to count values found in multiple ranges based on conditions. Please see the formula I've used in cell C2 in "reporting sheet"

Please Login or Register  to view this content.

When I press enter, excel is telling me that the formula contains an error.

The reason I'm + ranges as ONE is because two worksheets are involved for site a.

Do you understand where I am going with this? Maybe countifs is not suitable here when it comes to group two ranges as ONE RANGE to apply the conditions on?

Thank you for any possible guidance.

**Haseeb Avarakkan** · 12-16-2011, 09:34 PM

Can't use COUNTIFS like this, If you just have 2 sheets use 2 countifs like,

=COUNTIFS('Site A Main'!A:A,A2,'Site A Main'!B:B,B2,'Site A Main'!C:C,C2)+COUNTIFS('Site A sub'!A:A,A2,'Site A sub'!B:B,B2,'Site A sub'!C:C,C2)

If you have more sheets, you can use COUNTIFS with INDIRECT

**Lifeseeker** · 12-19-2011, 08:20 PM

Thanks.

I will give it a try!

Using two ranges as ONE RANGE in countifs with conditions. Formula returns an error

LinkBack

Thread Tools

Rate This Thread

Display

Using two ranges as ONE RANGE in countifs with conditions. Formula returns an error

Re: Using two ranges as ONE RANGE in countifs with conditions. Formula returns an err

Re: Using two ranges as ONE RANGE in countifs with conditions. Formula returns an err

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions