Formula ideas

Stacy Meadows

So here goes;

sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN}

Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match

I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??

Stacy Meadows

I overcome it ...

I used =sumifs({Oct22}, {RevPC}, postcode@row, {RevPN}, name@row)

seems to work thank you :)

Paul Newcome

Are you able to provide some screenshots for reference?

Stacy Meadows

I overcome it ...

I used =sumifs({Oct22}, {RevPC}, postcode@row, {RevPN}, name@row)

seems to work thank you :)