# Formula

#### Godbless

##### New Member
Hi

Does anyone know what formula is needed to get excel to calculate all A rates seperate from B rates and C rates example 10 A rates @ 50.00 9 B rates @ 40.00 and 6 C rates @ 30.00 so although the rates could be mixed up (not following in any particular order the result which I would like to appear on a separate spreadsheet would be A = 500.00 B = 405.00 C = 180.00 then to get them to total up = £1085.00

Hope this makes sense.
A 50.00
B 40.00 then separate sheet with answer a 100.00 b 40.00 c 60.00
A 50.00
C 30.00
C 30.00

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### Jonmo1

##### MrExcel MVP
Welcome to the board.

I think you're looking for Sumif

=SUMIF(A:A,"A",B:B) - would sum column B where column A = A
=SUMIF(A:A,"B",B:B) - would sum column B where column A = B
=SUMIF(A:A,"C",B:B) - would sum column B where column A = C

#### Gerald Higgins

##### Well-known Member
Lots of ways. A pivot table will do this for you.

Although if you have 9 B rates @ 40.00, that is presumably 360.00, not 405.00.

#### Godbless

##### New Member
Thanks jonmo1 and yes your quite right JH I was never good at maths

#### Godbless

##### New Member
formula

Hi

Sorry i never made myself clear

I have 4 columns in column G I have all the grades which could vary from B C A. In Column H Time in column I rate which differs for each grade and in J Amount.

What I am after is on my summary sheet it calculates hours and mins of all (A's, B's and C's in say column F. In column G counts the amounts of A's B's and C's separate rows and in column H the amount of time X' the Rate of each Grade on separate rows.

If you can solve this for me I will be so please

#### Gerald Higgins

##### Well-known Member
In what way exactly do the previously suggested solutions (SUMIF or PIVOT TABLE) not work ?

#### Godbless

##### New Member
I am not sure how to apply it to the spreadsheet I am using. Can it be simplified in anyway?

#### Gerald Higgins

##### Well-known Member
Highlight your data, then invoke the Pivot Table Wizard.

#### Godbless

##### New Member
SHEET 1 COLUMN
G H I J
ROW
A 0:24 50.00 £20.00
B 1:12 40.00 £48.00
C 2:30 20.00 £50.00
A 0:12 50.00 £10.00
B 0:24 40.00 £16.00
C 2:00 20.00 £40.00
C 3:00 20.00 £60.00
B 0:24 40.00 £16.00
COLUMNS
D E F G
Preparation rows 0:36 2 30.00 A
2:00 3 80.00 B
7:30 3 150.00 C
In the new spreadsheet (the summary sheet) I would like a formula to be set up so each time I enter the either work done by a b grade person or c garde person and a grade person at whatever hours or mins it updates the individua rows in in the summary sheet of each grade worker the hrs/ms the number and amount. I know I should use sumif but not sure how to apply it as I have never used it before. Should the formula be used on the summary sheet to grabe the information from sheet 1 g,h,i,j which is the sheet I am inputting the information.

Sorry

#### eliW

##### Well-known Member
Hi and God bless you!

This what I get using simple PIVOT TABLE

Suggest that you use PT to get exactly what you need:
Book1
ABCDEFGHIJK
2A0:245020
3B1:124048Data
5A0:125010A0:36230
6B0:244016B2:00380
7C2:002040C7:303150
8C3:002060GrandTotal10:068260
9B0:244016
10
Sheet1

Replies
3
Views
244
Replies
1
Views
233
Replies
0
Views
741
Replies
3
Views
184
Replies
1
Views
810

1,191,170
Messages
5,985,063
Members
439,938
Latest member
MAlhash

### 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.

### Which adblocker are you using?

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

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