Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Count 2 Columns
I will post the two formulas I am using now and I hope someone can help me figure out how to make it into 1. Thanks in advance. #1 =COUNTIF(location, "shop") total=20 #2 =COUNTIF(date,""&B10)-COUNTIF(date,""&B11) total=10 Explained(as the best I can) #1 It simply counts the number of times that the "Shop" was used all months #2 Counts the total number of times that "All" were used for a particular month. Goal I want to be able to count how many times the "Shop" was used in each particular month. I have the "Shop total" and the "All by month" but was looking to get "Shop by each month" Thanks in advance -- rileym ------------------------------------------------------------------------ rileym's Profile: http://www.excelforum.com/member.php...o&userid=37905 View this thread: http://www.excelforum.com/showthread...hreadid=574365 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Count 2 Columns
"rileym" wrote in message ... I will post the two formulas I am using now and I hope someone can help me figure out how to make it into 1. Thanks in advance. #1 =COUNTIF(location, "shop") total=20 #2 =COUNTIF(date,""&B10)-COUNTIF(date,""&B11) total=10 Explained(as the best I can) #1 It simply counts the number of times that the "Shop" was used all months #2 Counts the total number of times that "All" were used for a particular month. Goal I want to be able to count how many times the "Shop" was used in each particular month. I have the "Shop total" and the "All by month" but was looking to get "Shop by each month" Thanks in advance Please have a look at array formulas (http://www.cpearson.com/excel/array.htm) This technique is much more powerful than single COUNTIFs. Joerg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count non consecutive columns | Excel Worksheet Functions | |||
How do I count values across multiple columns? | Excel Worksheet Functions | |||
Sum Count of Single Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
count cells across muliple columns | Excel Worksheet Functions | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions |