Modify formula to reflect unique entires

**RodneyW** · 10-16-2010, 04:49 PM

This formula

=SUMPRODUCT((E$4:E$73=1)*($D4:$D73="KVRV"))

is working perfect. I'm using it five different times with the KVRV section changed to reflect the five different options that can go in column D.

Now I need to have a total of UNIQUE entries in Column B where Column E=1. Something like this:

=SUMPRODUCT((E$4:E$73=1)*($B4:$B73="different unique entries"))

Any ideas?

Thanks

**ratcat** · 10-16-2010, 10:01 PM

G'day

Since your using excel 2007 use the Countifs formula

Or if your sheet needs to be converted back to 2003 try

Please Login or Register  to view this content.

Tho I'm not clear on how your achieving in finding your unique.

Just throwing an idea around.

Cheers

RC

**DonkeyOte** · 10-17-2010, 03:28 AM

Originally Posted by RodneyW

Now I need to have a total of UNIQUE entries in Column B where Column E=1.

As RC mentions - if you're using XL2007 as implied by profile you can make use of COUNTIFS - in this particular context along lines of:

Please Login or Register  to view this content.

If you prefer to avoid COUNTIFS for sake of backwards compatibility you can use either of the below

Please Login or Register  to view this content.

Modify formula to reflect unique entires

LinkBack

Thread Tools

Rate This Thread

Display

Modify formula to reflect unique entires

Re: Modify formula to reflect unique entires

Re: Modify formula to reflect unique entires

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions