Conditional formula?

Giganews Newsgroups
Subject: Conditional formula?
Posted by:  y_not (y_not.2749ty_1146466801.2749@excelforum-nospam.com)
Date: Mon, 1 May 2006

Hi, I'm trying to find a way to total the number of cells that meet a
given criteria.

It works something like this: -

If [A1="Test"] AND [B1 is greater than zero] then [add to the number of
cells that meet this condition]

The formula will apply to 350 rows, cell in column A will contain one
of six options (all text) and column B will either have no value or
will have a numeric value.

I know this can be done but I am currently brain dead! Can anyone
advise, please?

Many thanks for all the help in the past.

Tony

--
y_not
------------------------------------------------------------------------
y_not's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=19947
View this thread:http://www.excelforum.com/showthread.php?threadid=537670

Replies