Forum Discussion
Solved
Excel formula SUMSIF or DATA/MATCH?
I'm trying to write a formula using SUMSIF to pull a total amount from a column based on date, market and eventid -- so three criteria. Two criteria are in vertical columns and one is in a horizonta...
How about using SUMIFS:
- Your data is on a sheet called Data and the columns are structured as follows:
- Date in column A
- Market in column B
- EventID in column C
- Amount in column D
- Your criteria (dates, markets, and event IDs) are in the current table where you're inserting the formula.
=SUMIFS(Data!D:D, Data!A:A, CriteriaDate, Data!B:B, CriteriaMarket, Data!C:C, CriteriaEventID)You'll replace CriteriaDate, CriteriaMarket, and CriteriaEventID with the relevant cell references in your current table.
- Your data is on a sheet called Data and the columns are structured as follows:
How about using SUMIFS:
- Your data is on a sheet called Data and the columns are structured as follows:
- Date in column A
- Market in column B
- EventID in column C
- Amount in column D
- Your criteria (dates, markets, and event IDs) are in the current table where you're inserting the formula.
=SUMIFS(Data!D:D, Data!A:A, CriteriaDate, Data!B:B, CriteriaMarket, Data!C:C, CriteriaEventID)You'll replace CriteriaDate, CriteriaMarket, and CriteriaEventID with the relevant cell references in your current table.
Thank you SO MUCH! I was trying to get there, but it wasn't working. I did have to exchange a couple of columns to get the dollars, but it works. Have a great weekend!
