• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

Sumproduct

Hi,

I need to find the sum of the volumes of transactions (based on ColG in Raw Data) in cell D3 in tab "Monthly"

I have some sumproduct for C3 and i want to expand that out so that i can calculate JKs volumes based on currency and name

Thanks
jk.xlsx
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=SUM(IFERROR((Name=A2)*--(CCY=B2)*GBPEQUIV,0))

Enter as array formula Ctrl-Shift-Enter

Regards
0
 
Seamus2626Author Commented:
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now