How to implement MS Excel's SUMIF function in Oracle Forms [message #487243] |
Fri, 24 December 2010 04:49 |
nikhilk411
Messages: 33 Registered: September 2010 Location: Mumbai
|
Member |
|
|
Hi,
I am trying to translate some input data given in MS Excel into Oracle Forms. The Excel sheet consists of usage of the SUMIF() to calculate the values. I am struggling to implement this in Oracle Forms.
I am attaching a screenshot with some sample data set to explain my problem in detail.
Can anyone kindly guide me how this can be implemented?
|
|
|
|
Re: How to implement MS Excel's SUMIF function in Oracle Forms [message #487256 is a reply to message #487250] |
Fri, 24 December 2010 06:23 |
nikhilk411
Messages: 33 Registered: September 2010 Location: Mumbai
|
Member |
|
|
Hi Michel,
The SUMIF function works as follows
=SUMIF(range,criteria,sum_range)
As in my sample dataset, --> =SUMIF($A2:$A6,A10,$C2:$C6)
This would SUM all numeric cells in the range C2:C6 where the corresponding row in A2:A6 is equal to, here in my case, A10, i.e "A"
You can refer to http://www.ozgrid.com/Excel/sum-if.htm if my explanation is not precise.
Thanks and Regards,
Nikhil
|
|
|
|
|
|
|