Sum = B3 if B1= Marketing

[DK Liner]

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.

 

[Eduardo]

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

 

[Sean Timmons]

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

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

 

[DK Liner]

Neither of the formulas worked. They both gave me a sum of "0"

 

[DK Liner]

It didn't work. It returned a sum of "0"

 

[Fred Smith]

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.

 

[Jacob Skaria]

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

 

[DK Liner]

I really appreciate your attempts but I think I will create a new format and
start over.

 

[Jacob Skaria]

Try the same in a new work sheet; please

If this post helps click Yes

 

[DK Liner]

Jacob,

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

Thank you very much.

D. Liner