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.
Is this possible?
- 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))
