unable to get formula to work

[Patcheen]

what is wrong with my formula i keep getting an error

=COUNTIFS('Game Data'!E$2:E3,='Shirt Database'!A3,'Game Data'!H3)

im trying to calculate if Game Data'!E$2:E3 = Shirt Database'!A3 and if thats correct then return the answer in Game Data'!H3

thank you for your help

 

[Marcílio_Lobão]

Patcheen, Good evening.

Your explanation is a little confuse.

Try to use:

Sheet: 'Game Data'

H3 --> =COUNTIF(E2:E3,'Shirt Database'!A3)

Is that what you want?

I hope it helps.

 

[Patcheen]

ya i think so

 

[Patcheen]

no there is numbers in H3:h100 on the game data sheet that im trying to calculate if the name in game data matches the name in shirt database A3 an the name changes when copied down

 

[Marcílio_Lobão]

Patcheen, Good morning.

I could not understand your observation.

Please, save your file at a free site, www.sendspace.com or other and put a link here do download.

Show your data and how would be the desirable result.
A concrete example, please.

It's easier to help you with your data in Excel.

 

[clatron]

if you are trying to return a value in a cell, you could try using SUMIFS instead of COUNTIFS - countifs will only count the times your criteria are met, when sumifs will total the value in a specified column when your criteria are met.

 

[Patcheen]

i apologize for delay in replying i been very busy but here is link to an sample file of what I'm trying to achieve

i Thank you all for your help


https://www.sendspace.com/file/dnexd3

 

[Patcheen]

any suggestions? im still trying but getting nowhere

 

[Patcheen]

i thought this was gonna be easy to solve but its harder than i thought

but thank you for your help

 

[jtakw]

Hi,

Have not looked at your file as signing up is required to download, looking at your formula in Post #9 , maybe you mean this, otherwise, please describe what the formula is supposed to do:

=SUMIF('Shirt Database'!$A$2:$A$10000,$A1,'Game Data'!$H$2:$H$10000)