LinkBack URL
About LinkBacks
Hi,
I am using this formula:
=SUM((N3:N1000<>"091")*(C3:C1000=80))
In the function argument window the result of this formula is 2 which is correct (see .jpg) but it display 0 on the worksheet.
Any ideas?
Any help would be great.
thanks
Hi,
I am using this formula:
=SUM((N3:N1000<>"091")*(C3:C1000=80))
In the function argument window the result of this formula is 2 which is correct (see .jpg) but it display 0 on the worksheet.
Any ideas?
Any help would be great.
thanks
It's an array formula.
Did you enter the formula using CTRL+SHIFT+ENTER
An alternative
=SUMPRODUCT(--(C3:C1000=80)*--(N3:N1000<>"091"))
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks