#### Catherine

##### New Member
Hello all,

I have a spread sheet where I am tracking holiday gifts - we have 4 different values (\$15, \$20, \$30, \$50). We have 450 employees from 14 different locations. Each person is getting a different gift value. (Because I have 14 different locations, I have rows with nothing or a zero value).

What's the fastest way to count how many of each denomination I will need to order?

Catherine

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### wwbwb

##### Well-known Member
say the denominations were in col a you could use countif

=countif(a:a,15)
=countif(a:a,20)
=countif(a:a,30)
=countif(a:a,50)

#### Brian from Maui

##### MrExcel MVP
Catherine said:
Hello all,

I have a spread sheet where I am tracking holiday gifts - we have 4 different values (\$15, \$20, \$30, \$50). We have 450 employees from 14 different locations. Each person is getting a different gift value. (Because I have 14 different locations, I have rows with nothing or a zero value).

What's the fastest way to count how many of each denomination I will need to order?

Catherine

What criteria do you use to determine who gets what gift?

Replies
1
Views
63
Replies
3
Views
205
Replies
0
Views
130
Replies
0
Views
114
Replies
10
Views
279