LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JonZ
 
Posts: n/a
Default Basic: Looking up Data in Range

This is probably basic stuff.

I presently use COUNTIF to count the number of instances of the letter
"x" or "o" in a column:
=COUNTIF(B:B,"x")

I need to find totals of one condition in a column when another column
has another condition.

In the following data range, for example, I might need to find the
number of times "x" appears in column B during a particular month, like
February, or during a certain time of day.

A B C
January 4 x morning
January 4 o afternoon
January 12 o morning
January 15 o morning
January 15 x afternoon
February 2 x morning
February 2 x morning
Ferbrary 4 o morning
February 10 x morning

I might also like to count, for example, the number of times "x"
apppears in the morning in February.

Please write out examples. My date format is MM-DD-YY.

 
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
Setting source data range with Charts D Charts and Charting in Excel 2 January 1st 06 02:51 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Vlookup of parts of a word in a range of Data Andre Croteau Excel Discussion (Misc queries) 3 December 19th 04 07:26 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 04:02 AM.

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

About Us

"It's about Microsoft Excel"