| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count certain values in a column
I'm designing a spreadsheet where column B contains the month and column C
contains a numerical value. Could anyone out there suggest a formula that only counts the values in Column B for the month contained in column C. B C April 1 April April 3 April 1 May June 1 June 1 June 1 July 3 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count certain values in a column
I should have written "only counts the values in Column C for the month
contained in column B." "Mark Corbett" wrote: I'm designing a spreadsheet where column B contains the month and column C contains a numerical value. Could anyone out there suggest a formula that only counts the values in Column B for the month contained in column C. B C April 1 April April 3 April 1 May June 1 June 1 June 1 July 3 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count certain values in a column
I am presuming you meant sum vlaues in col c for month in col B:
=SUMIF(a1:a24,"jan",b1:b24) Hope this is what you were after. "Mark Corbett" wrote: I should have written "only counts the values in Column C for the month contained in column B." "Mark Corbett" wrote: I'm designing a spreadsheet where column B contains the month and column C contains a numerical value. Could anyone out there suggest a formula that only counts the values in Column B for the month contained in column C. B C April 1 April April 3 April 1 May June 1 June 1 June 1 July 3 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count certain values in a column
Nav
Thanks, that's exactly what I wanted. Very helpful. Mark ------------------------------------------------ "Nav" wrote: I am presuming you meant sum vlaues in col c for month in col B: =SUMIF(a1:a24,"jan",b1:b24) Hope this is what you were after. "Mark Corbett" wrote: I should have written "only counts the values in Column C for the month contained in column B." "Mark Corbett" wrote: I'm designing a spreadsheet where column B contains the month and column C contains a numerical value. Could anyone out there suggest a formula that only counts the values in Column B for the month contained in column C. B C April 1 April April 3 April 1 May June 1 June 1 June 1 July 3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
Linear Mode
