Macro to derived results separately for two separate reference

[sakib]

Dear Forum Expert,

I have a spreadsheet That i need some help on. i this spread sheep already has buttons and other marcro in it. There is a Amazon and an Ebay Filter button on it as well which shows only sales for eBay and the other shows only sales for amazon. I already have a slot Q4 which shows the overall profit but I would like to see the individual profit totals for Ebay and Amazon at all times in lines U2 and U4. Can you do this?

Appreciate your prompt support.

Thanks and regards.

Sakib

[pjwhitfield]

It would be most helpful if you'd posted some actual data in there so we could see how you distinguish the two types.

Im guessing from looking at other bits that the following will work

in U2

Please Login or Register  to view this content.

and in U4
=SUMIF(AZ:AZ,"EBay",Q:Q)