Microsoft Office Forums - View Single Post - [Solved] How can I avoid doubles?

Thread: [Solved] How can I avoid doubles?

View Single Post

Old

05-10-2012, 06:04 AM

Peter Wienand Peter Wienand is offline

Peter Wienand is offline

Peter Wienand uses Windows Vista

Windows Vista Peter Wienand uses Office 2003

Peter Wienand uses Office 2003

Office 2003

Novice

Join Date: May 2012

Posts: 15

Peter Wienand is on a distinguished road

Default

I would have thought that adding multiple COUNTIF functions together should work. Would you be able to post a copy of your formula?

You could also try the COUNTIFS function, which is probably a more elegant solution than using multiple COUNTIF functions.

http://office.microsoft.com/en-us/ex...010047494.aspx

Reply With Quote