| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help writing function
Hi,
you could create a pivot table. Drag Days to the row area and numbers to the data area. Right click any number in the data area and select value field settigns. Change the "Summarise by" field from sum to count. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "LQQKB4uleep" wrote in message ... Column A has Days of the week listed for the entire month Column B has data listed for days of the week Want formula to count data in column B if it equals a certain day of the week like if sunday then count all data listed for sundays in column B "a" "B" Sunday 21 Monday 15 Tuesday 28 Sunday 14 Monday 10 Tuesday 12 sunday=35 Monday=25 Tuesday=40 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help With Writing Concatenate Function | Excel Worksheet Functions | |||
| Function writing help | Excel Worksheet Functions | |||
| WRITING A WHAT IF FUNCTION | Excel Worksheet Functions | |||
| Why doesn't writing a nested IF function work? | Excel Discussion (Misc queries) | |||
| Help Writing Function | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
