| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT using 2 different criterias
Hello. I'm trying to count how many days I worked remotly, how many days I
was sick and how many vacation days I took each month. Month Date Type Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day In this example, this would be the result: Jan Feb Mar Type 2 0 1 Work Remotly 1 1 0 Sick Day 0 0 1 Vacation Day What would the formula be to get those results? Thanks! Fatima |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT using 2 different criterias
With this data in the range A2:C7
Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day F1:I1 = headers = Jan Feb Mar Type I2:I4 = Work Remotly; Sick Day; Vacation Day Enter this formula in F2: =SUMPRODUCT(--($A$2:$A$7=F$1),--($C$2:$C$7=$I2)) Copy across to H2 then down to row 4 -- Biff Microsoft Excel MVP "fsfiligoi" wrote in message ... Hello. I'm trying to count how many days I worked remotly, how many days I was sick and how many vacation days I took each month. Month Date Type Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day In this example, this would be the result: Jan Feb Mar Type 2 0 1 Work Remotly 1 1 0 Sick Day 0 0 1 Vacation Day What would the formula be to get those results? Thanks! Fatima |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT using 2 different criterias
Hi
The easiest way is with a Pivot Table Place you cursor anywhere within your dataDataPivot TablesFinish On the Pivot Table skeleton that appears on the new sheet Drag Month to the column area Drag Type to the Row area Drag Type again to the Data area (where it will show Count of Type) -- Regards Roger Govier "fsfiligoi" wrote in message ... Hello. I'm trying to count how many days I worked remotly, how many days I was sick and how many vacation days I took each month. Month Date Type Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day In this example, this would be the result: Jan Feb Mar Type 2 0 1 Work Remotly 1 1 0 Sick Day 0 0 1 Vacation Day What would the formula be to get those results? Thanks! Fatima |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT using 2 different criterias
This is exactly what I was looking for! Thank you!
"fsfiligoi" wrote: Hello. I'm trying to count how many days I worked remotly, how many days I was sick and how many vacation days I took each month. Month Date Type Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day In this example, this would be the result: Jan Feb Mar Type 2 0 1 Work Remotly 1 1 0 Sick Day 0 0 1 Vacation Day What would the formula be to get those results? Thanks! Fatima |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT using 2 different criterias
Thanks a lot! This is what I was looking for. Fatima
"T. Valko" wrote: With this data in the range A2:C7 Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day F1:I1 = headers = Jan Feb Mar Type I2:I4 = Work Remotly; Sick Day; Vacation Day Enter this formula in F2: =SUMPRODUCT(--($A$2:$A$7=F$1),--($C$2:$C$7=$I2)) Copy across to H2 then down to row 4 -- Biff Microsoft Excel MVP "fsfiligoi" wrote in message ... Hello. I'm trying to count how many days I worked remotly, how many days I was sick and how many vacation days I took each month. Month Date Type Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day In this example, this would be the result: Jan Feb Mar Type 2 0 1 Work Remotly 1 1 0 Sick Day 0 0 1 Vacation Day What would the formula be to get those results? Thanks! Fatima |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT using 2 different criterias
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "fsfiligoi" wrote in message ... Thanks a lot! This is what I was looking for. Fatima "T. Valko" wrote: With this data in the range A2:C7 Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day F1:I1 = headers = Jan Feb Mar Type I2:I4 = Work Remotly; Sick Day; Vacation Day Enter this formula in F2: =SUMPRODUCT(--($A$2:$A$7=F$1),--($C$2:$C$7=$I2)) Copy across to H2 then down to row 4 -- Biff Microsoft Excel MVP "fsfiligoi" wrote in message ... Hello. I'm trying to count how many days I worked remotly, how many days I was sick and how many vacation days I took each month. Month Date Type Jan 5 Work Remotly Jan 6 Sick Day Jan 23 Work Remotly Feb 11 Sick Day Mar 16 Work Remotly Mar 17 Vacation Day In this example, this would be the result: Jan Feb Mar Type 2 0 1 Work Remotly 1 1 0 Sick Day 0 0 1 Vacation Day What would the formula be to get those results? Thanks! Fatima |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Sum functions with 2 criterias | Excel Worksheet Functions | |||
| Count for multiple text criterias | Excel Worksheet Functions | |||
| Count with multiple criterias | Excel Worksheet Functions | |||
| "Count If" 3 criterias are fulfilled | Excel Discussion (Misc queries) | |||
| Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
Linear Mode
