sum a constant value..

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

Hi

I've the following data:

Column A B C D(autonumber)
1721 Alpha 1000 101
1723 Beta 1000 105
1721 Alpha 500 107
1723 Beta 1000 101
1721 Alpha 1500 119

What i need is:
a) Sum of values in column C where column A = "1721"
b) For column A = "1721", the value in column C adds up every day. How can i
sum it up.


Please help.
 
=SUMIF(A:A,1721,C:C)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Deepak said:
Hi

I've the following data:

Column A B C D(autonumber)
1721 Alpha 1000 101
1723 Beta 1000 105
1721 Alpha 500 107
1723 Beta 1000 101
1721 Alpha 1500 119

What i need is:
a) Sum of values in column C where column A = "1721"
Click to expand...

Hi Deepak,

try,

=SUMIF($A$1:$A$5,1721,$C$1:$C$5)
b) For column A = "1721", the value in column C adds up every day. How can i
sum it up.
Click to expand...

I'm not sure what you mean by this. Or is this part of your first
question?

Hope this helps!
 
Hi Deepak

Then your number 1721 is text
Use this then

=SUMPRODUCT((A1:A12="1721")*(C1:C12))
 
Try my solution, no need to use sumproduct in this case, besides sumif got a
bug
so it will recognize both numeric 1721 and text "1721", Ron's formula
should work though,
try to change the criteria to "1721" as opposed to 1721 or vice versa.
My guess is that your column data in A is text

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top