Conditional Columns

Originally Posted by ChemistB

You could use Pivot tables or with January in D2, in E2

=SUMPRODUCT(--(TEXT($A$2:$A$19,"mmmm")=D2),$B$2:$B$19) dragged down
Does that work for you?

That would give you the sum. To average it, try

=SUMPRODUCT(--(TEXT($A$2:$A$19,"mmmm")=D2),$B$2:$B$19)/SUMPRODUCT(--(TEXT($A$2:$A$19,"mmmm")=D2))

Originally Posted by BenMiller

That would give you the sum. To average it, try

=SUMPRODUCT(--(TEXT($A$2:$A$19,"mmmm")=D2),$B$2:$B$19)/SUMPRODUCT(--(TEXT($A$2:$A$19,"mmmm")=D2))

When I tried this, I got #DIV/O!

What do you have in D2?

Originally Posted by BenMiller

What do you have in D2?

"February" its a text cell

Monthly Average.xlsxHere is an example:

Can't open that, sorry I have 2003