Trying to work smarter, not harder
 

Hello - I have been using excel for a while now but haven't taken the step to use the programming features. I have a need to use some advanced techniques but can't figure it out.

I have a chart set up like so

Heading 1 Heading 2 Amount

sort 1------sort a----------#
sort 1------sort a----------#
sort 1------sort b----------#
sort 2------sort c----------#

...etc.

What I'd like to do is run a program to sum all like Heading 1 - Heading 2 combinations and consolidate the chart. I remember back 10 yrs ago in my Qbasic and C++ classes that you could do it but don't remember how I did it and don't know how excel programming works. Any help would be appreciated, thanks!

Trying to work smarter, not harder
 

hi Richard,

i think that SUMPRODUCT function is appropriate for this problem,
look here : http://excel.bigresource.com/Using-S...-GbExuwXI.html

--
isabelle


Le 2012-09-06 15:07, Richard McShane a écrit :
Hello - I have been using excel for a while now but haven't taken the
step to use the programming features. I have a need to use some
advanced techniques but can't figure it out.

I have a chart set up like so

Heading 1 Heading 2 Amount

sort 1------sort a----------#
sort 1------sort a----------#
sort 1------sort b----------#
sort 2------sort c----------#

..etc.

What I'd like to do is run a program to sum all like Heading 1 - Heading
2 combinations and consolidate the chart. I remember back 10 yrs ago in
my Qbasic and C++ classes that you could do it but don't remember how I
did it and don't know how excel programming works. Any help would be
appreciated, thanks!