Originally posted by Ubasstards
Originally posted by tautology
Originally posted by Ubasstards
Originally posted by tautology
My flex point history is 4,412 lines long.
open microsoft excel
Highlight your flex point history
Copy
Paste Special into excel (Text)
Sort Data by column B
Highlight all next to "purchase" and read sum in bottom right of excel
20 seconds to answer IMO
ermm...how do you think I figured out how many lines there were? Did you think I counted them one by one?

Also: =sumproduct((A1:A4412="purchase")*(B1:B4412)) is my preferred method 
that method adds 2-3 seconds time.
If you needs some excel tips, please PM me. Hmm.
Maybe I should have used an array formala?
{=SUM(IF(A1:A4412="purchase",(B1:B4412),0))} (hit shift+ctrl+enter to create the array formula brackets).
This thread is now about excel skilz

(editted to correct formula...oops !)