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   Mar-08-2015
question by perplexed again:!mydiscussions/docs/p02jpEaCkHU
How do you state a range in the dsum critera argument?

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....


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.

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.