Posted to microsoft.public.excel.worksheet.functions

multiple conditions formula

Posts: n/a

How do I add multiple conditions to a formula?

Hi, I've tried using COUNT, SUM, SUMIF, COUNTIF, SUMPRODUCT, and nesting IF
functions, but I can't seem to get this formula to work.
control 0.122
GlcNAc 0.255
GlcNAc 0.478
control 0.377
control 0.301

I want to count the number of values for "control" between 0.3 and 0.4, and
have this count represented in a cell on a separate worksheet. Thanks a lot
for all your help.

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
Need help on formula with multiple conditions...	DiDi	Excel Discussion (Misc queries)	11	April 17th 06 05:33 PM
Multiple conditions in a formula	TV	Excel Worksheet Functions	3	April 12th 06 08:32 PM
formula to fill text with multiple conditions	jerry	Excel Discussion (Misc queries)	2	September 8th 05 11:26 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Sum(if ... multiple conditions ... Interpretation?	Ken	Excel Discussion (Misc queries)	6	December 16th 04 10:23 PM

All times are GMT +1. The time now is 02:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us