Can someone tell me the difference between these two formulas? Thanks! Amy
C cvgairport Jan 3, 2005 #1 Can someone tell me the difference between these two formulas? Thanks! Amy
C Chip Pearson Jan 3, 2005 #2 The primary difference is that DSUM requires that you use a range of cells as criteria, and that both the data range and criteria range have column header labels. SUMIF does not require either of these. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message news:[email protected]...
The primary difference is that DSUM requires that you use a range of cells as criteria, and that both the data range and criteria range have column header labels. SUMIF does not require either of these. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message news:[email protected]...
