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) )
Timothy_OM Perhaps a bit unconventional but usually you would just sum column B. But since it contains dates (that are also treated numbers) you could use this (transformed the list to a structured table):
=SUMIF(Table2[Column1],"<44000")
Why 44000? Because Excel treats dates as sequential numbers starting from 1 January 1900. Currently we are about 44000 (plus a few hundred) days away from that date. So, if the likelihood of dollar amount in column B being above USD 44,000 is minimal, you could use the above formula
Otherwise, use Power Query to do the heavy lifting for you, assuming your data contains more that just a few transactions, but with a $ amount, every 4th row.