Can these formulas work and how?

Tallie

New Member
Joined
Jan 9, 2014
Messages
24
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!
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
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

New Member
Joined
Jan 9, 2014
Messages
24
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,914
Messages
5,598,840
Members
414,261
Latest member
KatieBsc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top