I really appreciate your attempts but I think I will create a new format and
start over.
--
Impossible? NOT YET!

D Liner


"Jacob Skaria" wrote:

Hi "DK Liner"

Let us try the below test..

--Copy the below data in A:B to a sheet so that the data is arranged as
viewed below.
--In ColC we have the departments
--In ColD cell D1 apply the below formula which will add up all values in
ColB corresponding to the department in Column C
--The formula =SUMIF(A:A,"Admin",B:B) will add up all Admin entries..
--Try and feedback ..

Col A Col B Col C Col D
Education 1 Education =SUMIF(A:A,C1,B:B)
Marketing 2 Marketing =SUMIF(A:A,C2,B:B)
Admin 3 Admin =SUMIF(A:A,C3,B:B)
Education 4
Marketing 5
Admin 6
Education 7
Marketing 8
Admin 9
--
--
--

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


"DK Liner" wrote:

It didn't work. It returned a sum of "0"
--
Impossible? NOT YET!

D Liner


"Eduardo" wrote:

Hi
in G4 enter

=sumproduct(--($C$3:$C$100=G3),$F$3:$F$100)

copy formula to your right

if this helps please click yes thanks

"DK Liner" wrote:

C3 = either Member Services, Education, Marketing or Admin.
D3 = Qty Ordered (ea order)
E3 = Unit Price (per order)
F3 = Total (per order)

I need to have a colum for each dept. (Member Srvs, Education, etc) for each
day with a total for each dept.
so
Education Total is G3
Member Services is H3

Is it countif?......Or can you think of an easier format.

Thank you in advance.