Sumif/s or sumproduct help

[007Buff]

I have a spreadsheet that looks like this -

Column A Column B Column C Column D Column E Column F Column G Column H Column I
Team Buyer Price Team Buyer Price Team Buyer Price


I need to calculate how much each buyer has total across all columns. I know how to do it with just column B&C, but when I try to add E&F and H&I.

Let me know if you need more info or have questions. Thank you for your help.

[Jonmo1]

Try

=SUMIF(A:H,"buyer",B:I)

[007Buff]

So that would work for say just row 2 but I have multiple rows call it b2:b30="Buyer"),C2:C30), but then I need it to add these others do E2:E30="Buyer"),F2:F30) and H2:H30="Buyer"),I2:I30) it needs to tie the buyer and how much he has spent for a one total not 3 separate ones. Thank you for your help.

[Jonmo1]

Did you try it ?

[007Buff]

I didn't get that to work, so I tried to attach the spreadsheet(don't know if I did or not), but what I need is for cell c30 to total the dollar amount that mark spent, for the whole spreadsheet. Let me know if you have questions or if the attachment didn't work.

[AlKey]

Enter formula in C30 and copy down

Please Login or Register  to view this content.

[007Buff]

Thank you very much that worked!