Forum Discussion
Solved
How to sum one excel column just the dollar values shown here
How to SUM one excel column filtering out everything else, and keeping just the dollar values shown in attached file.
Not sure on which version of Excel you are, as variant
=SUM( INDEX(B3:B100, ROW(A1:A20)*4-1,1) )
Not sure on which version of Excel you are, as variant
=SUM( INDEX(B3:B100, ROW(A1:A20)*4-1,1) )WINNER WINNER CHICKEN DINNER!!
This is exactly what I was looking for -- simple, elegent, beautiful.
Thank you, Sergei.
Thank you for your response mathetes. YES as am tter of fact is it a bank statement.
Thanks everyone for the valuable input.
Best Regards, Timothy_OM
Timothy_OM , you ae welcome, glad it helped.
If you are on Excel 365 you could use something like
=SUM( INDEX( range, SEQUENCE( INT( ROWS(range) / 4)+1,,3,4)) )
