COUNT IF Formula

**freddie9090** · 02-25-2014, 10:32 AM

From the attached data is it possible to create a formula to count the number of staff in post that are line managers?

**sktneer** · 02-25-2014, 10:38 AM

Try this.......

Please Login or Register  to view this content.

**alansidman** · 02-25-2014, 10:39 AM

Try this: =SUMPRODUCT(($D$6:$D$13=1)*($E$6:$E$13="Yes"))

**alansidman** · 02-25-2014, 10:40 AM

@sktneer

OP profile is shown using XL2003. Countifs is not available in that version.

**sktneer** · 02-25-2014, 10:42 AM

@ alansidman

Oh yes. I didn't see that. Thanks for reminding though.

**freddie9090** · 02-25-2014, 04:07 PM

@alansidman thanks that works!

If the data was on Sheet 1 (as in the attached spreadsheet) and I was calculating the formula in Sheet 2 how would that change the formula?

**freddie9090** · 02-25-2014, 04:07 PM

@alansidman thanks that works!

If the data was on Sheet 1 (as in the attached spreadsheet) and I was calculating the formula in Sheet 2 how would that change the formula?

**sktneer** · 02-25-2014, 10:37 PM

In that case the formula will be like this.......

=SUMPRODUCT((Sheet1!D6:D13=1)*(Sheet1!E6:E13="Yes"))

COUNT IF Formula

LinkBack

Thread Tools

Rate This Thread

Display

COUNT IF Formula

Re: COUNT IF Formula

Re: COUNT IF Formula

Re: COUNT IF Formula

Re: COUNT IF Formula

Re: COUNT IF Formula

Re: COUNT IF Formula

Re: COUNT IF Formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count formula not count hidden cells in table

[SOLVED] Count and average formula needed to not count text field

[SOLVED] text count issue, it seems to count the formula also?

[SOLVED] Count/No Count for year entered---formula help

Count formula for dates greater than 30 days old with exclusions and not count blanks

Bookmarks

Bookmarks

Posting Permissions