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.

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.

not ereally necessary to have a sumproduct for this...

=SUMIF($C:$C,G3,$F:$F) will get it. Thinking this will calculate quicker.

"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.

Neither of the formulas worked. They both gave me a sum of "0"
--
Impossible? NOT YET!

D Liner


"Sean Timmons" wrote:

not ereally necessary to have a sumproduct for this...

=SUMIF($C:$C,G3,$F:$F) will get it. Thinking this will calculate quicker.

"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.

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.

Then:
-- your entry in G3 does not match anything in column C
-- or, you don't have numbers in column F (eg, you have text).

Sumif is a very common function, and millions of people use it every day.
We're sure you can join them with a little effort on your part.

Regards,
Fred.

"DK Liner" wrote in message
...
Neither of the formulas worked. They both gave me a sum of "0"
--
Impossible? NOT YET!

D Liner


"Sean Timmons" wrote:

not ereally necessary to have a sumproduct for this...

=SUMIF($C:$C,G3,$F:$F) will get it. Thinking this will calculate
quicker.

"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.

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.

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.

Try the same in a new work sheet; please

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


"DK Liner" wrote:

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.

Jacob,

You my friend, are my NBF!! That is it. Works perfectly.

Thank you very much.

D. Liner
--
Impossible? NOT YET!

D Liner


"Jacob Skaria" wrote:

Try the same in a new work sheet; please

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


"DK Liner" wrote:

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.