Hi All,

I am currently trying to use excel to sum up multiple criteria within a table, however one of the criteria requires (or so i believe) the use of the frequency function too. Would anyone be able to make any suggestions as to how to solve this?

Further detail:

The table houses a column for Name, Days and dates. I need it to find the matching "name" with matching "dates" (not all are the same) and then add the "days" that coincide with these criteria together.

The formula i have used so far will sum the "days" that correspond with the "name" but can't account for changing "dates", current formula is below;


=SUMIFS(Table1[days used], Table1[Name], "Mo", Table1[Valid From], C3)

Any help is greatly appreciated