| View previous topic :: View next topic |
| Author |
Message |
fcjdijkstra
General User
Joined: 30 Oct 2008
Posts: 6
|
 Posted: Thu Oct 30, 2008 2:00 am Post subject: Problems with SUMIF function |
 |
|
Dear,
I tried to receive a SUM of hours per product.
TO do this I use the formula:
=SUMIF(Producten_uur_per_Activiteit.$G$2:$G$1000;"=" & $K2;Producten_uur_per_Activiteit.T$1:T$1000)
The G Colum is a Colum of product id's
The T Colum is a Colum of hours.
Somehow I get results back which are not correct. For example I expect "0" as result and I get 0.25. I have no idea where 0.25 could come from.
Kind regards,
Frank Dijkstra |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Thu Oct 30, 2008 4:44 am Post subject: Re: Problems with SUMIF function |
|
|
| fcjdijkstra wrote: | Dear,
I tried to receive a SUM of hours per product.
TO do this I use the formula:
=SUMIF(Producten_uur_per_Activiteit.$G$2:$G$1000;"=" & $K2;Producten_uur_per_Activiteit.T$1:T$1000)
The G Colum is a Colum of product id's
The T Colum is a Colum of hours.
Somehow I get results back which are not correct. For example I expect "0" as result and I get 0.25. I have no idea where 0.25 could come from.
Kind regards,
Frank Dijkstra |
Hi Frank,
I don't see the problem but can I suggest that you ask this question in the Calc forum? The Math forum is for writing mathematical equations not for calculating things.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
fcjdijkstra
General User
Joined: 30 Oct 2008
Posts: 6
|
| Posted: Thu Oct 30, 2008 4:47 am Post subject: |
|
|
| I will, thank you |
|
| Back to top |
|
|
|
