Can these formulas work and how?

[Tallie]

The 2 formulas I am using is:

=COUNTIF('Mon Data'!K2:K30000,A43)

and

=SUMPRODUCT(--('Mon Data'!A2:A30000=Monday!A44),--('Mon Data'!H2:H30000="ATT"))

They are in different cells to achieve the different figures required and they work great for that.
However, I need to get the formula to divide the resulting figure by 2 but to still be in the same cell (so add something to the above formulas to get them to divide the number).

The data I am working with is not numerical so these formulas are counting up text entries to get to how many ATT there are for example.

Many thanks for any suggestions!

 

[Jonmo1]

Welcome to the board.

These should do that for you

=COUNTIF('Mon Data'!K2:K30000,A43)/2
and
=SUMPRODUCT(--('Mon Data'!A2:A30000=Monday!A44),--('Mon Data'!H2:H30000="ATT"))/2

 

[Tallie]

OMG what an idiot I am!! Of course that would work... One of those things I could've sworn I'd tried lol

Thank you so much for replying so quickly

 

[Jonmo1]

Glad to help, thanks for the feedback.