Hi,
Is it possible to use the below formula, but for it to not include rows that a certain colour?
=SUMPRODUCT(--($H$2:$H$65536=2),--($Y$2:$Y$65536=7),$AA$2:$AA$65536)/100
Hi,
Is it possible to use the below formula, but for it to not include rows that a certain colour?
=SUMPRODUCT(--($H$2:$H$65536=2),--($Y$2:$Y$65536=7),$AA$2:$AA$65536)/100
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks