I am trying to count up the responses from the tab "player games" by date. I do not want to add any of the data, just the total number of rows basically for each date and input the total into cell F9 of 'sheet 1'. Let me know if this is enough information.
Hi. Use this:
=COUNTIF(PlayerGames!$B:$B,Sheet1!N$7)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
=SUMPRODUCT(--(MOD(COLUMN($F9:$IV9)-COLUMN($F9),2)=0),$F9:$IV9)
use this to calculate total responses - will sum every second row
This was great Glenn - Thanks.Originally Posted by Glenn Kennedy
Next question. I want to use a SUMIF equation in this example.
I want to sum up the totals for each Mon, Tue, Wed, etc.
Thanks in advance.
=SUMIF(B33:B73,A11,C33:C73)
paste into B11 and copy down
does not work for some reason with Thursday - are they all spelt correctly
Last edited by nigelog; 06-17-2015 at 12:10 PM.
With a modification... the above should work OK, BUT there were no values in C to sum, only #VALUE errors, in the sheet that you posted.
=SUMIF($B$33:$B$73,A11,$C$33:$C$73)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks