count if help

[excelnovice936]

I attached aexample of what i am trying to look for. i am trying to come up with an equation where if it says home run on sheet 2 column B it will add up the hom eun total in column c of sheet 2. there are two sheets so please look at both. and thanks fo rthe hlp in advance!sample.xlsx

[Tony Valko]

First...

In your Type of hit data there are space characters at the end of every cell that contains Home run. Remove those space characters!

Then...

On Sheet1:

A2 = 6/1/2014
B2 = 6/10/2014
C2 = Home Run

Formula in D2:

=SUMIFS(Sheet2!C2:C11,Sheet2!A2:A11,">="&A2,Sheet2!A2:A11,"<="&B2,Sheet2!B2:B11,C2)

[Vikas_Gautam]

Try this..
Definitely help you...

Please Login or Register  to view this content.

Use ctrl + shift + enter to enter the formula..

Don't forget to click *

[Tony Valko]

=SUM(IF(Sheet2!$B$2:$B$11="Home Run ",Sheet2!C2:C11))

Looks like you're missing the date conditions.

[Vikas_Gautam]

But OP has provided the data.. From 1 June to 10 june..
I think there is no need for that...

I he wants that we will definitely be providing that..



Don't forget to click *

[Tony Valko]

In that case a simple SUMIF will do:

=SUMIF(Sheet2!B2:B11,"Home Run",Sheet2!C2:C11)

Although, I think the OP does intend to use a specific date range.

Don't forget to remove those trailing space characters!