Calculations

[Patcheen]

im trying go calculate teams info

easier to show than explain but here goes

arsenal is in column A5:a3000 and their game played 42 twice so 84 goes in sheet full data "B5"

heres a link to an example book
https://www.sendspace.com/file/wsaxti

 

[Patcheen]

im using this formula =SUMIF('Raw data'!C5:$C$3000,'Full data'!A5,'Raw data'!D5) but its not calculating correctly

Any ideas?

 

[jtakw]

Hi,

It's probably a better idea to show a sample table with your question if you can, rather than for potential helpers to have to Download a file, a lot of us are not keen to downloading unknown files.

Your formula should be: =SUMIF('Raw data'!$C$5:$C$3000,'Full data'!$A5,'Raw data'!$D$5:$D$3000)

 

[Patcheen]

Thank you so very much thats cracked it i see i wasnt too far away from the solution thank you so very much

 

[jtakw]

You're very welcome, glad to help.