Counting horizontal and vertical cells based on two conditions

If it's only five columns across, then probably the simplest construction would be to five COUNTIF functions.

Please Login or Register  to view this content.

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Assuming your staff grades are in B1 to B10 and your duties are in C1 to J10, use this:

=SUMPRODUCT((C1:J10="telephone")*(B1:B10="Manager"))

Normally I wouldn't bother mocking up anyone's sheet for them, but I'm bored today.....

Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

I just opened your attachment. For the final formula, use this:

=SUMPRODUCT(($C$1:$G$10=C$14)*($B$1:$B$10=$B15))