Posted to microsoft.public.excel.misc

perale

external usenet poster

Posts: 6

IF THEN statements

Thanks Rick. That worked.

"Rick Rothstein" wrote:

Try this formula instead...

=SUMPRODUCT(($A2:$A$174=1)*($B$2:$B$174="A-1"))

--
Rick (MVP - Excel)

"perale" wrote in message
...
I have 2 columns A & B. I want Xcel to first look at Column A and IF it
contains the number 1, then go to Column B and count how many A-1's there
are. This is my formula - it's giving me a FALSE answer but I need a
number.

=IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1")

.

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
If Statements	Sr Accountant[_2_]	Excel Discussion (Misc queries)	3	October 12th 07 07:45 PM
if then statements	Rhonda	Excel Worksheet Functions	6	September 6th 07 02:22 PM
IF statements	Excel Function Application[_2_]	New Users to Excel	9	June 30th 07 02:54 PM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
using if statements	LAybar	Excel Worksheet Functions	4	March 20th 06 02:55 PM

All times are GMT +1. The time now is 10:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us