Sumif

[Insomnia01]

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

B:B	P:P
A	#
B	#
C	#
D	#
A	#
C	#
C	#
B	#
A	#

<tbody>
</tbody>

Sorry if this has already been answered.

Thank you

 

[Special-K99]

Isn't this just

=SUMIF(Sheet1!P1:P1000,Sheet1!B1:B1000,"A")+SUMIF(Sheet2!P1:P1000,Sheet2!B1:B1000,"A")

 

[Insomnia01]

Hey,

Thanks for reply.

It doesnt seem to work. It errors the whole formula as incorrect.

 

[Special-K99]

Got me paramaters wrong way round.

=SUMIF(Sheet1!B1:B1000,"A",Sheet1!P1:P1000)+SUMIF(Sheet2!B1:B1000,"A",Sheet1!P1:P1000)

 

[Insomnia01]

Fantastic,

That did it's purpose!
Many thanks for that!