If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional sum, wizard or otherwise
Hello, All!
There was a question recently on numerical integration. I can see how to do it using Simpson's rule and the most appropriate function would be SUMIF but, if there are two columns, x and y, I cannot think how to sum the y-values when x is odd using ISODD (or equally ISEVEN). Can someone point me in the right direction? I could write an expression using IMOD but that seems clumsy. Thanks in Advance! James Silverton Potomac, Maryland, USA |
#2
|
|||
|
|||
Conditional sum, wizard or otherwise
James wrote to All on Fri, 20 Jan 2006 18:36:42 -0500:
JS There was a question recently on numerical integration. I JS can see how to do it using Simpson's rule and the most JS appropriate function would be SUMIF but, if there are two JS columns, x and y, I cannot think how to sum the y-values JS when x is odd using ISODD (or equally ISEVEN). Can someone JS point me in the right direction? I could write an JS expression using IMOD but that seems clumsy. I should mention that I have seen various approaches involving helper columns and I successfully did that with results that were pretty good using a function that I could integrate exactly to allow checking. James Silverton. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Format Not Working | KMH | General Discussion | 0 | December 22nd, 2005 05:32 PM |
Conditional Sum Wizard: Error: "Randomized Numbers" | Charlie Rowe | General Discussion | 1 | November 21st, 2005 08:04 PM |
In MS Word 2000, where is the web page wizard? | Andy | General Discussion | 0 | January 6th, 2005 05:45 PM |
Problem accessing SQL Server in upsizing wizard | Edward | General Discussion | 1 | July 5th, 2004 06:00 AM |
Import Text Wizard - how do I get it to always appear? | Dave Peterson | Setting up and Configuration | 0 | March 23rd, 2004 01:37 AM |