Hi,
I am trying to sum a range of data based on two critier in two columns. Below are the example,
ColA ColB ColC
1 OnShore 80
2 OffShore 20
3 OnShore 50
1 OffShore 50
1 OnShore 50
Basically, I need to report for the above data with the same ColA and ColB criteria. I could get to the result with the concatenation with sumif(). I wonder if there is any better formula to summarize the result for ColC with the same ColA and ColB?
Thanks,
Howdy
I am trying to sum a range of data based on two critier in two columns. Below are the example,
ColA ColB ColC
1 OnShore 80
2 OffShore 20
3 OnShore 50
1 OffShore 50
1 OnShore 50
Basically, I need to report for the above data with the same ColA and ColB criteria. I could get to the result with the concatenation with sumif(). I wonder if there is any better formula to summarize the result for ColC with the same ColA and ColB?
Thanks,
Howdy