I have the following formula in my 2007 excel worksheet and I want to pass this workbook on to someone who is running in excel 2003. How do I change the COUNTIFS formula to work in excel 2003?
Thanks,
=(A14="","",SUMIF(Records!B:B,A14,Records!D:D))-COUNTIFS(Records!C:C,"Y",Records!B:B,A14)*$F$1
Adam.
Hi, you could
Replace COUNTIFS(Records!C:C,"Y",Records!B:B,A14)
with SUMPRODUCT((Records!C1:C65536="Y")*(Records!B1:B65536=A14))
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks