Try the below. Please note that this is an array formula. Within the cell in
edit mode (F2) paste this formula and press Ctrl+Shift+Enter to apply this
formula. If successful in 'Formula Bar' you can notice the curly braces at
both ends like "{=<formula}"

=AVERAGE(IF(TEXT(B1:B100,"mm")="07",D1:D100))

If you want to ignore blanks and zeroes try the below version
=AVERAGE(IF(TEXT(B1:B100,"mm")="07",IF(D1:D1000,D 1:D100)))

If this post helps click Yes
---------------
Jacob Skaria


"mbr" wrote:

i need to be able to capture the average of amounts in column d if column b
is between 1/7/9 and 31/7/9. can it be done?

"Jacob Skaria" wrote:

The below function will return 10 if the month of date in B2 is 7.

=IF(--TEXT(B2,"mm")=7,10,0)

=IF(--TEXT(B2,"mm")=7,"True","False")


If this post helps click Yes
---------------
Jacob Skaria


"mbr" wrote:

what function would i need to do the following:

add amounts in column d if column b is between 01/07/09 and 31/07/09.