Hello
I would like a formula to pick up two elements, both currency and cost description, and to sum based on that.
I have tried and failed to figure out the sumproduct and index/match
Would appreciate some tips
Many thanks, Maddy
Hello
I would like a formula to pick up two elements, both currency and cost description, and to sum based on that.
I have tried and failed to figure out the sumproduct and index/match
Would appreciate some tips
Many thanks, Maddy
Last edited by overbomb; 03-22-2012 at 07:04 AM.
Hi
Fill out some data and show expected results
Also write the somproduct formula you used
Regards
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
In B4, enter =SUMPRODUCT((DATA!$I$2:$I$38=B$4)*(DATA!$J$2:$J$38=$A5)*DATA!$G$2:$G$38) and drag it down and across
Did this solution work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks