Need help with formula similar to a sumifs.

[owen4512]

Hello,

I'm asking for some help with a formula.

I'm making a booking system for a theatre and i'm trying to make it show how many seats are available in a certain category.

I've set it out like this,

http://i.imgur.com/R6fag7I.png

So this is what i need help with,
I want it so i looks for the name of the shoe (Sioe), checks what type of seat has been booked (Math o Sioe) and the counts counts only the quantity (Cyfanswm Ymwelwyr) of the type of shoe.

=SUMIF($P$2:$P$100,$AA$6,$Q$2:$Q$100)
Is there another formula i can use for this?

Thanks in advanced,

Owen.

 

[RonB1111]

SUMIFS will handle multiple criteria, try this in AB6:

=SUMIFS($Q$2:$Q$100,$O$2:$O$100,AA5,$P$2:$P$100,AA6)

 

[owen4512]

Thank you, worked perfectly.

 

[RonB1111]

You're welcome!