Adding up common denominations

Catherine

New Member
Joined
Jun 8, 2004
Messages
41
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
 

Some videos you may like

Excel Facts

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

wwbwb

Well-known Member
Joined
Oct 20, 2003
Messages
513
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
Joined
Feb 16, 2002
Messages
8,458
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,234
Messages
5,571,045
Members
412,359
Latest member
misstoffeepenny
Top