Count Function Error

[Tgpitch16]

How do I have the COUNT function ignore cells with formulas? The formula is below.

=IF(COUNT(C5,D5,E5,F5,G5)=1,((H5/1))*5-I5,IF(COUNT(C5,D5,E5,F5,G5)=2,((H5/2))*5-I5,IF(COUNT(C5,D5,E5,F5,G5)=3,((H5/3))*5-I5,IF(COUNT(C5,D5,E5,F5,G5)=4,((H5/4))*5-I5,IF(COUNT(C5,D5,E5,F5,G5)=5,((H5/5))*5-I5,"")))))

 

[joeu2004]

[.... deleted by me ....]

 

[joeu2004]

Ignore cells based on what condition(s)?

If based on simply whether or not they are a number (implied by your use of COUNT), try:

=IFERROR(5*H5/COUNT(C5:G5)-I5, "")

Otherwise, you might consider using COUNTIF or COUNTIFS instead of COUNT.

 

[Aladin Akyurek]

Care to elaborate? What kind of formulas do the cells you want to ignore house?

 

[Tgpitch16]

That didn't work either. Essentially what I am doing is trying to predict a trend. Let's say the goal is 100 for the week (M-F) and I get 5 on Monday, I would be trending -75. Each cell is referencing another spreadsheet for the value, and some of them are blank based on the day.

Appreciate your help.