SUMIF formula - multiple ranges?

[ChocksterNo1]

Hi

I have a large spreadsheet with several tables.

One table requires a SUMIF formula to look at 3 other tables.

Currently the formula looks like this.

=P15-SUMIF(ATable[Account],$D265,ATable[Apr])

I need the formula to also include PTable[Account] & FTable[Account] in the range section
and in the sum range section - PTable[Apr] & FTable[Apr]

Is there an easy way to do this?

Many thanks

Chock

[duncandhu]

I think you would have to add 2 more SUMIFs to the formula with the criteria you are mentioning.

Thanks
Duncan

[CRIMEDOG]

=P15-(SUMIF(ATable[Account],$D265,ATable[Apr])+SUMIF(PTable[Account],$D265,PTable[Apr])+SUMIF(FTable[Account],$D265,FTable[Apr]))