COULD SOMEONE HELP WITH THIS FORMULA. i NED IT TO COUNT ISSUSE!S1086:S1753 IF IT = 1 AND ALL THE OTH CONDITIONS ARE TRUE.HTML Code:
THANKS IN ADVANCED
COULD SOMEONE HELP WITH THIS FORMULA. i NED IT TO COUNT ISSUSE!S1086:S1753 IF IT = 1 AND ALL THE OTH CONDITIONS ARE TRUE.HTML Code:
THANKS IN ADVANCED
The ranges are all different sizes and referencing different rows....is that right? Should they not all be within the same row group (i.e. all criteria within rows 1086 and 1753)?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yes they should. I had a filter on when I did it.Originally Posted by NBVC
so then something like this should work...
Please Login or Register to view this content.
I'm getting a value errorOriginally Posted by NBVC
Check that there are no #VALUE! errors within any of those ranges referenced in the formula....
I get the error every time I add the second condition.Originally Posted by NBVC
Then there must be something wrong with that range... are they formula results in that range....are you sure there are no errors?
Maybe you can attach a zipped Excel2003 or earlier copy of your workbook here and I can look at it for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks