Combining 2 formulas

  • Thread starter Thread starter tcapewell
  • Start date Start date
T

tcapewell

Hi,

I'm an inexperienced Excel user but learning as I play around.

I'm trying to create a worksheet to record my football team's seaso
data and am wanting to count the number of times a person scores in
particular match

I have the first COUNTIF formula:
=COUNTIF(Match1!G17:I26,Match1!B26)

but I want to include an additional formula to enter a "-" if th
result of the COUNTIF formula equals 0

Again I have worked out how to change a 0 to "-" using the I
function:
=IF(COUNTIF(Match1!G17:I26,Match1!B27)=0,"-")

but I want to combine the two formulas so that Excel carries out th
first COUNTIF formula operation and then the second IF formula if th
the result of the first is 0.

I suspect a macro would perform this task easily but I've never use
them or don't really know what they're about.

Any help would be greatly appreciated

Thanks

To
 
Hi
try
=IF(COUNTIF(Match1!G17:I26,Match1!B27)=0,"-",COUNTIF(Match1!G17:I26,Mat
ch1!B27))
 
Back
Top