Hello everyone.
I am trying to do a SUMIF where the range consists of multiple columns and rows rather than just a single column.
for example:
<tbody>
A
B
C
D
1
Store 1
Store 2
Store 3
Store 4
2
London
Chicago
Paris
5
3
Paris
NY
Ottawa
18
4
Edinburgh
Ottawa
Paris
21
5
Edinburgh...