Posted to microsoft.public.excel.worksheet.functions

Johndb

external usenet poster

Posts: 16

countif with AND comparing 3 columns

Need help.

Ineed to add an AND command to the following formula and can't seem to
figure it out.

=SUM(IF(ISNUMBER(G3:G37),IF(ISNUMBER(H3:H37),IF(H3 :H37=G3:G37,1,0))))

It also needs to check if b3:b37 is = to "S"

Any assistance would be geatly appreciated.

Warmest Regards,

John

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 comparing two columns	Johndb	Excel Worksheet Functions	4	July 20th 09 11:21 AM
comparing 2 columns	rodchar	Excel Discussion (Misc queries)	2	June 24th 09 02:47 PM
comparing 2 columns	mariekek5	Excel Discussion (Misc queries)	6	June 17th 09 02:51 PM
COUNTIF/SUMIF comparing two rows of data	[email protected]	Excel Worksheet Functions	3	November 30th 07 04:46 PM
Comparing two columns of information with 2 new columns of informa	cbuck	Excel Discussion (Misc queries)	1	January 16th 07 09:49 PM

All times are GMT +1. The time now is 02:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us