Search results for query: *

Hi socomfort Try the following =SUMPRODUCT(0+(MONTH(Sheet1!$A:$A)=MONTH(Sheet2!B7))) Regards Laurie

Hi Althea The main problem as already mentioned is the varying number of words making up the Street and the town-state-zipcode. My approach for a similar problem was this. 1 On a COPY of the worksheet Insert new column A,do a fill series 1...40000 make header "Index" . This will allow you...

Hi bilbonvidia I have created a formula using sumproduct function will make the goal seek easier Gross Pay 409.44 band 10500 201.9230769 Taxcode 885 170.1923077 Sum of 201.92+170.19 372.1153846 Tax & NI 57.85 Net 351.59 Tax Table Inc Level Tax...

Hi wjmcgreevey: You have introduced column "U" and a "score" category. Without knowing how they were constructed we can't tell. In each of Zathras,Rofeo, and Yogi's formulas the assumption is your data starts in A1 and you want every 5th number to sum The "ROW-Mod" formula is directly related...

Hi Roel Zathras's formula will work, however over a large spreadsheet the array formula will be less efficient than yours. As wjmcgreevy data started at T5 (the 5th row)the Mod function needs to be adjusted as mentioned in earlier post and the "5" changed to 14 representing the "Nth" row to...

As your data starts at row 5 (T5)then Zathras formula would need to be modified to adj the MOD-ROW reference as below Also note the change to sum the 14 instead of 5th row =SUMPRODUCT(T5:T6000,IF(MOD(ROW(T5:T6000)-4,14),0,1)) Remember Ctrl+Shift+Enter Laurie