SumIf Lookups

Great if you have multiple values to lookup, for example, if you want to see the total value for conversions on every Monday of the year

 

sumif excel

 

See example spreadsheet below

 

Sumif_Example

Advertisements