Forum Discussion
SUMIFS to read a date and match by month
Hello! I am hoping to get help with formulas in Column I and J to summarize the data in the first section. Hoping to use SUMIF to add up the Miles and Supplies based on the date that is in Column C...
sumifs need range references, so you can not transform the date into month directly in the sumif functions.
sugget to use sum or sumproduct
=sumproduct(f2:f200*(text(c2:c200,"mmmm")=h2))
sugget to use sum or sumproduct
=sumproduct(f2:f200*(text(c2:c200,"mmmm")=h2))