Hi All,
Just joined, been searching topics but could not figure this out. I'm familiar to using SUMIF, COUNTIF etc but recently attempting to use SUMPRODUCT due to its ability to work with closed workbooks.
I am looking to sum the total of numbers in columns C, D, E providing the corresponding row in column A does not match two possible text strings, for example lets call these " 'R6 - Oil Drill " and " 'Spanner " (another words I want to exclude these two).
Just to complicate matters slightly, columns C, D, E do often contain blank cells which I understand SUMPRODUCT can sometimes count? (these are the columns were the values are kept). Column A will contain values between A2:A16 that i want to evalute for the criteria.
Let's call the workbook im writing the formula in Capacity and the workbook with the data i want to reference Volume.
Thanks in advance for any help
Bookmarks