Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default countif column d equals x and column a noblank

total of a column where the text is "X" and the name column is not blank.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,091
Default countif column d equals x and column a noblank

For which version of Excel?

"Willie Wilson" <Willie wrote in message
...
total of a column where the text is "X" and the name column is not blank.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default countif column d equals x and column a noblank

Try this:

=SUMPRODUCT(--(A1:A10<""),--(D1:D10="x"))

--
Biff
Microsoft Excel MVP


"Willie Wilson" <Willie wrote in message
...
total of a column where the text is "X" and the name column is not blank.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default countif column d equals x and column a noblank

=SUMPRODUCT(--(LEN(TRIM(a2:a23))0),--(d2:d23="x"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Willie Wilson" <Willie
wrote in message
...
total of a column where the text is "X" and the name column is not blank.


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default countif column d equals x and column a noblank

2003 excel

"Tyro" wrote:

For which version of Excel?

"Willie Wilson" <Willie wrote in message
...
total of a column where the text is "X" and the name column is not blank.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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: 2 criteria: Date Range Column & Text Column MAC Excel Worksheet Functions 14 September 16th 08 04:39 PM
countif Column A and excule column B if it's cancelled LLWest Excel Worksheet Functions 4 October 31st 06 11:47 PM
How do I Excel countif column a =? and column b = null ? tiff Excel Worksheet Functions 1 November 30th 05 01:29 PM
How to sum items from column A only if Column B row equals X BM Excel Worksheet Functions 1 September 17th 05 05:56 PM
Countif Text equals the same tamato43 Excel Discussion (Misc queries) 1 March 31st 05 01:24 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"