Posted to microsoft.public.excel.worksheet.functions

BlueWolverine BlueWolverine is offline

external usenet poster

Posts: 36

Anyway to put logic into a single countif, sumif etc?

Is there anyway to countif for multiple things?

like = countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos within a
countif or do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with AND logic	Mitchell_Collen via OfficeKB.com	Excel Worksheet Functions	8	June 19th 07 11:02 PM
Countif Using Multiple Logic Tests	Carl	Excel Worksheet Functions	3	June 4th 06 07:09 AM
Using 'AND' logic in a SUMIF statement	IpcTrain	Excel Worksheet Functions	2	March 10th 06 05:39 PM
COUNTIF with Logic?	Leonhardtk	Excel Worksheet Functions	3	January 10th 06 11:09 PM
Countif with AND logic	mlkpied	Excel Worksheet Functions	8	December 9th 04 11:47 AM

All times are GMT +1. The time now is 08:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us