| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quarterly figures with criteria
I have the following formula, giving me quarterly values. I need to add a
criteria "apples" to give me quarterly figures for that item. Any ideas? {=SUM((A5005=ROUNDUP(MONTH($A$4:$A$5000)/3,0))*$D$4:$D$5000)} This code is as an array. Is it best to use arrays or formulas? -- AOP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add figures to existing figures in excel | Excel Worksheet Functions | |||
| How to calculate quarterly | New Users to Excel | |||
| Changing positive figures to minus figures | Excel Worksheet Functions | |||
| Quarterly tax percentages | Excel Worksheet Functions | |||
| Adding the sum of figures in one column if they meet 2 criteria | Excel Worksheet Functions | |||
Threaded Mode
