Excel formula needed

Microsoft Excel 2003 (full product)
April 19, 2010 at 12:13:32
Specs: Windows Vista
I am creating a workbook to keep track of my fantasy baseball teams. Each week I have a different opponent in 10 categories. R, HR, RBI, SB, etc. I want to create cells that keep track of how many weeks I won and how many my opponents won. Say for runs one week I had 57 and they had 55 and then the next week i lost 51 to 46. I have the workbook set up so in cell O3 is says "them" and O4 says "me". I need a formula that says in P3 next to "them" 1 because they won one week and in P4 1 because I won one week. I was thinkinking of a combination of a SUM and IF formula but I do not know how to write it, thank you.

See More: Excel formula needed

Report •

#1
April 19, 2010 at 12:31:28
I'm a little confused about the lay out of your workbook.

You mention some single cells - O3 and O4 - and then you say you want "Sum" something.

You can COUNT values over a range:

=COUNTIF(O3:O7,"them")

For the table below, this would return 3.

You can use SUMIF to look at one range and SUM another based on what is in the first range.

=SUMIF(O3:O7,"them",P3:P7)

This will SUM the values in P3:P7, but only in those rows where "them" appears in O3:O7.

e.g. For the table below, it would return 6.


      O        P
3    me        1
4    them      2
5    them      1
6    me        2 
7    them      3



Report •
Related Solutions


Ask Question