Quarterly figures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Is this an Excel question? Try the Excel newsgroups...this is FrontPage.
--
===
Tom [Pepper] Willett
Microsoft MVP - FrontPage
"You're a daisy if you do!"
---
FrontPage Support:
http://www.frontpagemvps.com/
===
: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
 
Back
Top