if text equal count

[luisitocarrion1900]

I need a formula that i can put in a sheet named Calculation B:54 that if in sheet named Raw Data anywhere column D there the words "AIM 2019" it will add the total numbers in Column G of sheet named Raw Data.

 

[Paul Ked]

enter =IF( in your formula bar and follow the prompts. If you need more help, click on fx

 

[Michael M]

Is "AIM 2019" the only text in the cell / s or is it part of a longer text ??

 

[luisitocarrion1900]

AIM 2019 is the only text

 

[Paul Ked]

Did you try my post #2 ?

It's a very basic IF function and 'You can do it!' Give it a go... we'll help if you struggle but one has to learn

 

[Scott Huish]

I believe it's a SUMIF solution, not an IF solution:

=SUMIF('Raw Data'!D:D,"AIM 2019",'Raw Data'!G:G)

 

[Paul Ked]

my only mitigation is that it was in the small hours of the morning, sorry