Countif function

Closed
shifingclock - Feb 8, 2010 at 11:11 PM
 shifingclock - Feb 9, 2010 at 04:57 PM
Hello and help!

I am trying to look at two ranges, one range is Cost Centre (and there are 1000 of these) and reason codes (30 of these), range references, i.e.

Cost Centre = h9:h48 example say "accounting 1"
Reasoncode = G9:g48 example say "reason A"

Over both ranges, I want to count how many reason A's there are for Accounting 1.

Results Accounting 1 = Reason A = 2
Accounting 2 = Reason A = 1
Human Resources = Reason A = 6

etc...
Ive tried a countif AND function but its not working..

Much appreciated,

Edddy
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 9, 2010 at 04:51 AM
try something like this

=sumproduct((g9:g48="accounting 1")*(h9:h48="reason 1"))
0
Thank you so much, I can sleep now. Eddy
0