## Saturday, March 7, 2015

### yogi_Compute Sum Of Entries In Column D When Column B=B3 Column C='B' And Month Of Dates In Column A is equal to Month(A3)

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-08-2015
question by perplexed again:
How do you state a range in the dsum critera argument?
Hi,

I have the following formula which I am trying to use to determine a sum of "Deposit" for a "Partner" within a data range ie. B4:eomonth(b4,0). However I have had no luck in coming up with a way to specify it. The formula works for other criteria using specific dates but....

=dsum(Transactions!\$A\$2:\$D\$240,Transactions!\$D\$2,{{"Partner";B\$3},{"Category";"Deposit"},{"Date";\$b\$4:eomonth(\$b\$4,0)}})

b4 is a date = first day of the month.

This formula is used outside of the transactions tab. And while were at it how can I dynamically set \$d\$240 in the formula to the max length of the current list?

Here is an example of the transactions tab.

Thanks
----------------------------------------------------------------------------------------------------------------------------------
I assume when you mean Category 'Deposit' ... that is represented by 'B' in Column C of sheet named transactions.  If you want to
transfer the calculations to sheet named February, make the necessary adjustments.