Sum if horizontal and Vertical criteria matches

[nilani]

Hi,

I have a table with my P&L figures in it, by month for the year.

I want to set a formula that will pull through total sum based on the month that has been selected and the category selected in the rows.

I tried sumproduct, but it's not working for me I'm getting a #Div0 error.

Any help would be gratefully received.

Thank you

Nilani

[CARACALLA]

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[nilani]

Hi,

I am looking for a sumif/ sum product formula that can return the result based on the horizontal and vertical criteria's being met.

I have attached a sample spreadsheet.

I'd be grateful for any help.

Many thanks

N

[CARACALLA]

D19=sumifs(index(c4:j13,,match(d18,c2:j2,0)),b4:b13,c19)


D19=SUMPRODUCT((B4:B13=C19)*(C2:J2=D18)*(C4:J13))

[nilani]

Amazing - thank you!!!