LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaydubs
 
Posts: n/a
Default Countif on two columns in a sheet

Hello fellow Excellians,

On my last question I got a perfect answer. I wanted to know how many times
a particular value could be found in a certain column in a certain tab.

Now I want to know how I can use the same by selecting two values. I have a
sheet with the following values.

Date In (Column A)
Number (Column B)
Solved by (Column C)
Flow (Column D)
Cause (Column E)
etc, etc

Now I want to know how many times the person (in Column C) has solved a
particalur issue concerning a Flow (Column D). With selecting only one value
(for the situation how many times does a certain person solve an issue you
will use the following statement =COUNTIF($F$2:$F$12336;c1) ). But how do you
include an and in this statement as you make a selection on two different
values.

I will be very gratefull for your answer.

--
** Fool on the hill **
 
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
hiding columns, error message says cannot shift objects off sheet JORGE ORTIZ Excel Discussion (Misc queries) 11 August 19th 08 10:34 AM
Using CountIf with criteria on another sheet Lee Hunter Excel Worksheet Functions 6 November 3rd 05 03:21 PM
Countif in two columns and in different cells ferde Excel Discussion (Misc queries) 2 October 7th 05 08:31 PM
how do I create more than 266 columns in an excel sheet? Tolo Excel Discussion (Misc queries) 3 September 23rd 05 06:55 PM
Columns in excel sheet Waseem Setting up and Configuration of Excel 1 December 27th 04 06:06 PM


All times are GMT +1. The time now is 04:26 PM.

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"