SUMIF help please

**floricita** · 09-19-2012, 05:28 AM

Hi, I need to populate the attached table from the data page.

I was hoping that a sumif functuon would do it.

Thank you

**Jockney** · 09-19-2012, 05:33 AM

Put this in Cell B5 on the Table Tab

=SUMPRODUCT((Data!$A$5:$A$26=Table!$A5)*(Data!B$5:B$26))

Then copy across to all the cells. That should do it for you. Let me know if there's any problems and I'll help.

**floricita** · 09-19-2012, 05:37 AM

Thanks worked a treat

**Cutter** · 09-19-2012, 10:31 AM

The SUMIF() you asked for would be:

=SUMIF(Data!$A$5:$A$26,Table!$A5,Data!B$5:B$26)

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.