| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF formula Using 2 or more cells
Hi,
I am just exploring more with Excel. I am going to paste the table in and explain what I am trying to acheive. A B 1 31/04/2010 (month of reporting, Displayed as April, 2010) 2 3 12/04/2010 Vocational Assessment 4 15/03/2010 Vocational Assessment 5 01/04/2010 Vocational Re-Education I am trying to Count how many Vocational Assessment have the Date in the month of April. Does anyone know the best formula to use. I have used =SUMPRODUCT((A3:A5="31/03/2010")*(B3:B4="Vocational Assessment")) This does calculate and count them however this would count 3 as the formula is counting them as if they are single. I need it to count if it includes Date in April and Vocational Assessment. I hope I am making sense. please if anyone can help it would be uch appreciated. Sarah |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF formula Using 2 or more cells
Try the below
=SUMPRODUCT((TEXT(A3:A10,"mmmyyyy")="Apr2010")* (B3:B10="Vocational Assessment")) -- Jacob (MVP - Excel) "SarahN" wrote: Hi, I am just exploring more with Excel. I am going to paste the table in and explain what I am trying to acheive. A B 1 31/04/2010 (month of reporting, Displayed as April, 2010) 2 3 12/04/2010 Vocational Assessment 4 15/03/2010 Vocational Assessment 5 01/04/2010 Vocational Re-Education I am trying to Count how many Vocational Assessment have the Date in the month of April. Does anyone know the best formula to use. I have used =SUMPRODUCT((A3:A5="31/03/2010")*(B3:B4="Vocational Assessment")) This does calculate and count them however this would count 3 as the formula is counting them as if they are single. I need it to count if it includes Date in April and Vocational Assessment. I hope I am making sense. please if anyone can help it would be uch appreciated. Sarah |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF formula Using 2 or more cells
Thankyou so much you are a star!! The formula worked perfectly and has saved
so much time. STAR "Jacob Skaria" wrote: Try the below =SUMPRODUCT((TEXT(A3:A10,"mmmyyyy")="Apr2010")* (B3:B10="Vocational Assessment")) -- Jacob (MVP - Excel) "SarahN" wrote: Hi, I am just exploring more with Excel. I am going to paste the table in and explain what I am trying to acheive. A B 1 31/04/2010 (month of reporting, Displayed as April, 2010) 2 3 12/04/2010 Vocational Assessment 4 15/03/2010 Vocational Assessment 5 01/04/2010 Vocational Re-Education I am trying to Count how many Vocational Assessment have the Date in the month of April. Does anyone know the best formula to use. I have used =SUMPRODUCT((A3:A5="31/03/2010")*(B3:B4="Vocational Assessment")) This does calculate and count them however this would count 3 as the formula is counting them as if they are single. I need it to count if it includes Date in April and Vocational Assessment. I hope I am making sense. please if anyone can help it would be uch appreciated. Sarah |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using countif on non-consecutive cells | Excel Worksheet Functions | |||
| countif formula using named cells | Excel Worksheet Functions | |||
| How can I 'CountIf' alternate cells? | Excel Discussion (Misc queries) | |||
| How can I use the COUNTIF formula on a group of specific cells? | Excel Discussion (Misc queries) | |||
| How do I sum cells that have values from a countif formula? | Excel Worksheet Functions | |||
Linear Mode
