Find and Total a range of cells

George T

New Member
Joined
May 19, 2009
Messages
46
I am trying to get this formula to find a match in coulmn C And Total all data in columns D,E,F,G,H from cell 13 thur 33. Then I want to divide that sum by cell I9 in order to get a percentage. This is my formula below:

=IF($J15=0,"",SUMIF($C$13:$H$35,J15,$D$13:H33))
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
Maybe like so:

Excel Workbook
CDEFGHIJKL
13123456
14223456
153234565100
16423456
17523456
18123456
19223456
20323456
21423456
22523456
23123456
24223456
25323456
26423456
27523456
28123456
29223456
30323456
31423456
32523456
33423456
34323456
35523456
Sheet3
 

Watch MrExcel Video

Forum statistics

Threads
1,123,531
Messages
5,602,209
Members
414,513
Latest member
junbuggle

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top