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)

             Google Spreadsheet   Post  #1912
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-08-2015
question by perplexed again:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!mydiscussions/docs/p02jpEaCkHU
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.


No comments:

Post a Comment