Insomnia01
New Member
- Joined
- Oct 11, 2018
- Messages
- 3
Hi,
Ive been trying to wrap my head around doing a formula to sum up a product from a list of numbers in 2 different sheets.
The situation is, I have a list of areas which repeat themselves a few times over in B:B and a range of numbers in P:P. The tables are exactly the same in sheet 1 and sheet 2.
Id like the formula to sum every number from P:P only when a certain criteria appears in that row in B:B.
Example
Sum all rows from both sheets when B is the criteria
<tbody>
</tbody>
Sorry if this has already been answered.
Thank you
Ive been trying to wrap my head around doing a formula to sum up a product from a list of numbers in 2 different sheets.
The situation is, I have a list of areas which repeat themselves a few times over in B:B and a range of numbers in P:P. The tables are exactly the same in sheet 1 and sheet 2.
Id like the formula to sum every number from P:P only when a certain criteria appears in that row in B:B.
Example
Sum all rows from both sheets when B is the criteria
B:B | P:P |
A | # |
B | # |
C | # |
D | # |
A | # |
C | # |
C | # |
B | # |
A | # |
<tbody>
</tbody>
Sorry if this has already been answered.
Thank you