Countif Formula - is it possible to count occurrences of number and add them together?

[Liz23]

So I have a formula which counts the number of appointments/applications etc. for a number of different consultants, e.g.. Matt, where a number 1 has been placed under the Appointment column, but in some cases under the Applications column I have had to place a 3 or 4 depending on the situation. Can I get the countif formula to not only count the occurrences but add them together?

This is an example of the formula:

=COUNTIFS(TM!C88:C104, "Matt",TM!J88:J104, "1")+COUNTIFS('Web Org'!E113:E131, "Matt",'Web Org'!L113:L131, "1")

How do i recognise the other numbers (probably only going up to 10) without having to do another formula for each number (the real formula is really long, above is only an example and i will quickly run out of characters if i had to do another formula for each number.

I would appreciate any help with this

Thanks

[vlady]

maybe it's better to post a sample of your work to further analyze the data include expected outcome..

[Liz23]

I would have to create a new spreadsheet with example info on it because the actual file is too large and complicated and has confidential information in it. It will take me a little while but I'll work on it and post back when i can, thanks

[Liz23]

I think I may need to use the sumproduct function but i don't know how to use that...

[Liz23]

Ok, I just changed it to this and I am 80% sure it is working

+SUMPRODUCT(--('Web Org'!E113:E131="Matt")--('Web Org'!L113:L131>0))

I'm going to test it a bit more then come back and close thread or cry for help if need be!

Thanks for your responses so far

[Liz23]

Nup, it's not working, it's counting up 4 where there are none. I'll try to get a sample of the file

[vlady]

try
=sumif('Web Org'!E113:E131,"Matt",'Web Org'!L113:L131)

[Liz23]

Yep I'm pretty sure that is working, one of them is adding incorrectly but i think thats just a glitch. So thank you so much for your help!