Sumif

**legepe** · 11-07-2009, 06:47 PM

Hi all,
can anyone tell me if there is a different way to calculate this formula?

=SUMIF(S:S,">10000",Q:Q)-AA17-AA16-AA15-AA14-AA13-AA12

instead of using ">10000" when i use a cell reference it does not recognise the value in the cell.
also, there are several other cells that have the same formula ie -AA16-AA15-AA14-AA13-AA12
i am deducting the results from these cells that are already calculated to get the correct total of cell values that have only 10000 in this formula example.
i hope that i am explaining ok..
Any help would be very much appreciated..
thanks
legepe

**Richard Buttrey** · 11-07-2009, 07:04 PM

Hi,

Assuming cell ref is A1

Please Login or Register  to view this content.

Rgds

**shg** · 11-07-2009, 07:15 PM

Legepe,

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**legepe** · 11-07-2009, 08:57 PM

hi
hope the title is ok.. sorry for not reading the rules...
thanks for the help..
legepe

**legepe** · 11-07-2009, 10:20 PM

hi again,
i have another probrem...
the result from this formula = a period of 304 days and i want to display it as month if i put at the end of this /304*365/12 it gives me a wrong result..
=SUMIF(S:S,">"&X34,Q:Q)-SUM(AA33)
can you help me again...
thanks
legepe

**Richard Buttrey** · 11-08-2009, 09:40 AM

Hi,

Can you clarify exactly what you mean. If it returns a number 304 which represents days, what month do you expect that to be? Month 10 - October? If you're starting at 1st Janary then one way is:

Please Login or Register  to view this content.

HTH

**legepe** · 11-08-2009, 05:06 PM

sorry for the bad explanation..
i meant that this forula won't work and gives the wrong results...
=SUMIF(S:S,">"&Y41,Q:Q)-SUM(AB33:AB40)/304
i managed to do it now but using a different cell range.. but thanks for all your help anyway.
legepe

**legepe** · 11-08-2009, 06:29 PM

I now have a completely different problem...
i have a list of names and values in one worksheet and i want to display them in a different worksheet only if the value is more than what is specified.
I have this formula =IF(List!S6>List!Y$12,List!O6,0) which works for cell, but it is dependant on the row and i have more than 16000 rows with names and values..
do i need to use macro's for this. if so, i will be pritty much lost..!
if you can help it would be great...
thanks
legepe