Prev: Additonal info into newly created Subtotal row
Next: Macro to get rid of #DIV/0!
From: Ziggy on 31 Mar 2010 17:26
Bill, your formula works great.

How would you modify that to also yield a YTD result, i.e., Aug is
selected it sums Jan through Augus from the same dropdown.
From: T. Valko on 31 Mar 2010 21:59
You'd have to use a different function.

A2:A15 = cost center
B2:B15 = account codes
D1:O1 = column headers as month names (January, February, March, etc.)

Lookup values:

A17 = some cost center
B17 = some account code

A18 = drop down list with the month names (January, February, March, etc.)

=SUMPRODUCT((A2:A15=A17)*(B2:B15=B17)*D2:D15:INDEX(D2:O15,,MATCH(A18,D1:O1,0)))

--
Biff
Microsoft Excel MVP


"Ziggy" <ziggy943(a)xmission.com> wrote in message
news:109fdc41-432a-46be-90b3-a6030d82ebc7(a)10g2000yqq.googlegroups.com...
> Bill, your formula works great.
>
> How would you modify that to also yield a YTD result, i.e., Aug is
> selected it sums Jan through Augus from the same dropdown.


First  |  Prev  | 
Pages: 1 2
Prev: Additonal info into newly created Subtotal row
Next: Macro to get rid of #DIV/0!