Thanks for that... I can't use the first half as I don't know what my range is as the nr of rows always varies, however I can utalise one of my existing formulas and add -SUMPRODUCT(COUNTIF(I2:I20,Sheet2!N2:N3)) to get the figures I require.
Thanks for that... I can't use the first half as I don't know what my range is as the nr of rows always varies, however I can utalise one of my existing formulas and add -SUMPRODUCT(COUNTIF(I2:I20,Sheet2!N2:N3)) to get the figures I require.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks