# Formula Needed to count a range of cells based on criteria in 2 other cells

1. ## Formula Needed to count a range of cells based on criteria in 2 other cells

For this example I will use A1:A10, B1:B10, C1:C4 and D1:D4

A1:A10 = An Employee ID number; either 1, 2, 3, or 4
B1:B10 = 2 letters will be entered in these cells which represent a type of sale. "A" and "U"
C1:C4 = formula (where the totals will appear based on criteria entered in A1:A10 and B1:B10) Only count if "A" is entered
D1:D4 = formula (where the totals will appear based on criteria entered in A1:A10 and B1:B10) Only count if "U" is entered

Can someone help me with this? thanks

2. ## Re: Formula Needed to count a range of cells based on criteria in 2 other cells

Assuming thath you need to count 1,2,3,4 and "U" and then 1,2,3,4 and "A"
=COUNTIFS(A2:A10,1,B2:B10,"U")
Change 1 to 2 then to 3 and then change U to A

3. ## Re: Formula Needed to count a range of cells based on criteria in 2 other cells

thank you, works great

4. ## Re: Formula Needed to count a range of cells based on criteria in 2 other cells

You are welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1