Tagged Questions
0
votes
1answer
418 views
How can I run SUMIF or COUNTIF with two Conditions?
I recently got some great help with SUMIF and COUNTIF and ended up with the following, working formulas;
=SUMIF(REC!$F:$F,$C2,REC!$G:$G)
=COUNTIF(REC!$F:$F,$C2)
I had been mixing up the syntax and ...
1
vote
1answer
469 views
How to use countif, sumif across two sheets where the logical test is an equivalency?
I am building a simple sum sheet that relies on a conditional but I can't seem to get COUNTIF/SUMIF to work for me.
To sum, I have two sheets, one with a few hundred lines of records including an ...
5
votes
2answers
637 views
Excel: Counting number of MAX values in a range
I am using Excel 2003 (version limited due to corporate policy) to keep a score sheet:
A B C D
1 Round | Rita | Sue | Bob
------+------+-----+-----
2 1 | 5 | 3 | 4
3 ...
