Solved

# Using SUMPRODUCT to add values

Posted on 2013-09-21
Medium Priority
303 Views
Hello, I have this formula which sounds the number of transactions between two dates with the value PAID by it in the spreadsheet.

=SUMPRODUCT((Transactions!B:B>=C4)*(Transactions!B:B<=D4)*(Transactions!L:L="Paid"))

It works well, however can I use this same formula with SUMPRODUCT to count the transaction value (which is in column G for each row it matches)

Thanks,

GISVPN
0
Question by:gisvpn
• 2

LVL 81

Accepted Solution

byundt earned 2000 total points
ID: 39511625
You most certainly can use SUMPRODUCT to both add up values as well as count:
=SUMPRODUCT((Transactions!B:B>=C4)*(Transactions!B:B<=D4)*(Transactions!L:L="Paid")*(Transactions!G:G))
0

LVL 81

Expert Comment

ID: 39511627
You can also use a SUMIFS formula, which may be faster to calculate:
=SUMIFS(Transactions!G:G,Transactions!B:B,">=" & C4,Transactions!B:B,"<=" & D4,Transactions!L:L,"Paid")
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.