Posted to microsoft.public.excel.worksheet.functions

J.A.1975

external usenet poster

Posts: 2

COUNTIF with 2 columns

Hi, how do I count cells in A with nothing in B.

A B
x
x 2011/02/17
2011/03/21
x
x 2011/04/11
x

=COUNTIF(A:A;"x") but not counting when date (B:B) is available (it
means it did arrive)

Best regards,
Alberto

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 using two columns?	Scott Stedman	Excel Discussion (Misc queries)	6	May 7th 11 12:59 PM
CountIf 2 columns	Phippsy	Excel Discussion (Misc queries)	3	April 26th 10 03:13 PM
COUNTIF - across 2 columns	Rebekah	Excel Worksheet Functions	11	November 9th 09 03:43 PM
Countif for 2 columns	earlfj	Excel Worksheet Functions	3	September 27th 09 05:42 AM
countif in 2 columns	Tonso	Excel Discussion (Misc queries)	4	October 23rd 07 04:51 PM

All times are GMT +1. The time now is 11:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us