Hi Guys,
apologies if this has been answered before. i have a table which needs to look for specific values and if that value does not exist in the cell count another cell.
so what i mean by this is:
the table i have is the below:
<tbody>
</tbody>
i have been using =SUMIF(July!K:K,"<>Ad Hoc Task*""<>*invoice*",July!J:J)
but it does not seem to be counting them correctly. it should be looking in my main table column K if the values (Ad Hoc Task & invoice) are in the cell (keep in mind there is multiple values in the cell) then don't count it, if they are not in the cell count column J or H whichever has a value.
can someone help with this?
thanks!
apologies if this has been answered before. i have a table which needs to look for specific values and if that value does not exist in the cell count another cell.
so what i mean by this is:
the table i have is the below:
Category | Time |
Database | 1:35 |
Other | ???? |
<tbody>
</tbody>
i have been using =SUMIF(July!K:K,"<>Ad Hoc Task*""<>*invoice*",July!J:J)
but it does not seem to be counting them correctly. it should be looking in my main table column K if the values (Ad Hoc Task & invoice) are in the cell (keep in mind there is multiple values in the cell) then don't count it, if they are not in the cell count column J or H whichever has a value.
can someone help with this?
thanks!