Hi
I have issue with Countif function.
I have following formula in E10 cell
=IF(COUNTIF(G10:V10,$E$4)=0,"",COUNTIF(G10:V10,$E$4))
and following in F10 cell
=IF(COUNTIF(G10:V10,$F$4)=0,"",COUNTIF(G10:V10,$F$4))
I am trying to add the value together form cell E10&F10 into cell D10, BUT it produces #VA:UE!.
All i am trying to do is not to display ZERO in Countif formula and add to cell together.
PLEASE CAN SOMEONE HELP ME.
Regards
try this...
=sum(E10:F10)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
HiOriginally Posted by FDibbins
I can't use SUM function as cell has TEXT data, that the reason why i have to use COUNTIF.
REgards
SUM() ignores text values so it should not be a problem.
You could simply use in E10
=COUNTIF(G10:V10,$E$4)
and format cells as 0;-0; to hide (not display) zero values and similarly for F10.
Life's a spreadsheet, Excel!
Say thanks, Click *
I wasnt suggesting you replace your count formula, I meant use SUM() to add the 2 answers together.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks