Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JO
 
Posts: n/a
Default count based on two fields - need quickly

HELLO,
I am trying to get a count based on two fields.
I want to return the count based on if cells in col B = X and cells in col
A = Y
I have tried "=COUNTIF(H23:H999,A1) + COUNTIF
(B23:B999,A8)" but it is giving me the count of the result plus the count
of the second result.
Can anyone help.


  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default


=SUMPRODUCT(--($H$23:$H$999=A1),--($B$23:$B$999=A8))

JO Wrote:
HELLO,
I am trying to get a count based on two fields.
I want to return the count based on if cells in col B = X and cells in
col
A = Y
I have tried "=COUNTIF(H23:H999,A1) + COUNTIF
(B23:B999,A8)" but it is giving me the count of the result plus the
count
of the second result.
Can anyone help.



--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274346

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
Sorting Spreadsheet with Merged Fields Linda L Excel Discussion (Misc queries) 1 January 22nd 05 01:58 AM
formula based on format James Kendall Excel Discussion (Misc queries) 4 December 16th 04 05:47 PM
filter and count rexmann Excel Discussion (Misc queries) 2 November 30th 04 03:11 PM
How can I use count function in excel where I have several criter. Princess V Excel Worksheet Functions 14 November 3rd 04 11:18 PM
Count rows based on multiple criteria Murph Excel Worksheet Functions 1 October 28th 04 07:13 AM


All times are GMT +1. The time now is 02:41 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"