Could anyone point me in the correct direction with my problem?
Having trouble with quotes and whatever i do i dont get this to work.
Please Login or Register to view this content.Appreciate all answers.Please Login or Register to view this content.
Whats, the formula supposed to look like?
What is it you're trying to achieve, maybe a sample workbook might make it clearer.
CHAR(34) is for " in Excel however your criteria for the second countif reads like:
& ">=0" &
Which doesn't make any sense
Try this...
"=COUNTIFS(Sheet1.!F10:F109,C7,Sheet1.!L10:L109,"">=0"")"
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
This was my problem:
this is my solution and works:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks