LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I count items based upon two separate values?

How do I get Excel to count the number of times two or more given values
occur together? I have a list of projects and one of the columns is "Area"
and another column is "Size." The "area" column has repeating values and
those values have different corresponding "size" values. How do I get Excel
to count the number of time a given combination of "area" and "size" occurs?
For example, "Far East" and "5-1/2"? There would be multiple "Far East"
entries but I am only interested in the number of time "5-1/2" occurs with
"Far East."

Thanks
 
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
how do I filter a list of items based on values in another sheet jumpsystems Excel Discussion (Misc queries) 0 June 8th 07 12:10 PM
2 conditions needed to check and count of items based on that Vijay Excel Worksheet Functions 2 May 3rd 07 10:21 PM
Using SUMPRODUCT to count values in separate columns S Stunell Excel Worksheet Functions 4 October 19th 06 11:31 AM
Counting based on values in two separate columns Wayne Excel Worksheet Functions 3 August 30th 06 07:43 PM
Adding Values Based on a Separate Column binder Excel Discussion (Misc queries) 2 February 14th 05 07:17 PM


All times are GMT +1. The time now is 05:09 PM.

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"