Hi, I've been struggling to find out why sheet 2 isn't calculating. I looked through a dozen+ videos found nothing worked. If anyone could please help with this, thank you kindly.
Hi, I've been struggling to find out why sheet 2 isn't calculating. I looked through a dozen+ videos found nothing worked. If anyone could please help with this, thank you kindly.
what is it you are summing? Have you used this formula before with results?
it looks like you should be using countifs but I'm not sure what outcome you are looking for.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try this formula in C5 and adjust the rest to match.
=SUMPRODUCT((Participants!C$2:C$1001=1)*(Participants!$F$2:$F$1001=$A5))
But as Sam said, you could use COUNTIFS to be more efficient.
=COUNTIFS(Participants!C$2:C$1001,1,Participants!$F$2:$F$1001,$A5)
Beth.
You can use SUMIFS or COUNTIFS, depending on what data you are putting in your Participants table.
=SUMIFS(Participants!C$2:Participants!C$1001,Participants!$F$2:Participants!$F$1001,$A5)
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks