Sum Range Based on 3 Criteria

[Joor]

Good day, first time poster. I have searched this forum and tried examples of SUMIF, SUMPRODUCT but none seem to do what I'm looking for. Any help would be greatly appreciated.

In the attached example you'll see a sample data table that could be 1000s of rows long. It contains location, shape, date and some values. I would like to summarize the data by showing the total count (positive or negative) based on location, shape and date. Please note that the table could contain blank values.

(sorry couldn't seem to get the interlace to let me attach a file)
excel.PNG
(I also realized I misspelled Canada in the summary table example. Please proceed as if spelled correctly, Thank you.)

[kersplash]

Have you tried using a pivot table?

[xlnitwit]

You could also use SUMIFS
=SUMIFS(C$2:C$8,$A$2:$A$8,$A13,$B$2:$B$8,$B13)
and fill down and across

[63falcondude]

Hello and welcome to the forum.

A screenshot isn't as helpful as a sample workbook which you can upload here by clicking on GO ADVANCED and then scrolling down to Manage Attachments to open the upload window.

That being said, based on the screenshot that you shared in post #1, try this in C13:

=SUMIFS(C$2:C$8,$A$2:$A$8,$A13,$B$2:$B$8,$B13)

Drag the formula to the right and down.

[pella88]

Try this:

=SUM(IF($A$2:$A$8=$A$13,IF($B$2:$B$8=$B13,IF($C$1:$J$1=C$12,$C$2:$J$8))))

[CARACALLA]

https://dropfile.to/7FJMNqz

link for file