Hi
If the values in column A are true Excel dates e.g. 01/01/2006, then
=SUMPRODUCT(--(MONTH($A$1:$A$100)=1),$B$1:$B$100)
Change the =1 to =2 for Feb etc., or put the value required in another
cell. e.g cell C1, then
=SUMPRODUCT(--(MONTH($A$1:$A$100)=C1),$B$1:$B$100)
If the values in column A are text e.g. "January", then change formula
to
=SUMPRODUCT(--($A$1:$A$100)=C1),$B$1:$B$100)
and type January in C1
--
Regards
Roger Govier
lreque wrote:
I'm working on a worksheet and I need to write a formula - if the
cells in column a = January (or specified month), then add the cells
in the same row of column b. I want to compile date from an annual
forecast and I'd like to use a formula rather than doing it manually
- is this possible?
--
lreque
------------------------------------------------------------------------
lreque's Profile:
http://www.excelforum.com/member.php...o&userid=30078 View
this thread: http://www.excelforum.com/showthread...hreadid=497587