I am trying to SUM total dollar values by quarter. I have submitted dollars in Column F and the projected Quarter in Column J. I want to sum to show in cell A8 for Q1.
HEre's the IF statement I tried.
=IF(A8=SUM(F14:F113),SUMIF($J$14:$J$114,LEFT(A4,2),$F$14:$F$113))
Bookmarks