Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.

Sum = B3 if B1= Marketing
 

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.