Dave-

Thank you very very much!!! This worked like a charm!!

Dave Peterson wrote:
=sumproduct(--(b1:b600="AM"),--(c1:c60030))
and
=sumproduct(--(a1:a600="Call"),--(b1:b600="AM"),--(c1:c60030))

Adjust the ranges to match--but you can't use whole columns (except in xl2007).

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

==========
You may want to add headers (in row 1) and add a formula in column D.

Formula in D2:
=if(c230,1,0)
and drag down

Then you could use that table to create a pivottable.

Select the table (a1:D601)
data|pivottable
follow the wizard until you get to a step with a Layout button on it.
Click that button.

Drag the header for Column A to the Row field
Drag the header for column B to the column field
drag the header for column D to the Data field
If the header for column D doesn't show "Sum of" Cancel this and go back to the
original table and make sure your formula is correct in D2:D601.

Then finish up this pivottable.

I am having major trouble with a countif formula

[quoted text clipped - 24 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1