sum a column if another column does not contain specific text

[DMO123]

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:

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!

 

[steve the fish]

See if this works:

=SUMIFS(July!J:J,July!K:K,"<>*Ad Hoc Task*",July!K:K,"<>*invoice*")+SUMIFS(July!H:H,July!K:K,"<>*Ad Hoc Task*",July!K:K,"<>*invoice*")

 

[DMO123]

@stevethefish thats the one - thank you!