Two cells, one is $$

Jramos413

Hello! I am very new at trying to graph and formulas. I am trying to graph dollars associated with service type. They are in side by side cells. For example: Each OPD has a different dollar amount tied to it. I need a sum of all OPD dollars. I would appreciate any assistance.

James Keuning

In the Sheet Summary, put:

=SUMIF(Metric:Metric, "OPD", Value:Value)

If you want to create another sheet, where you can roll up the totals for all categories, you can use a cross-sheet reference.

James Keuning

In the Sheet Summary, put:

=SUMIF(Metric:Metric, "OPD", Value:Value)

If you want to create another sheet, where you can roll up the totals for all categories, you can use a cross-sheet reference.

Jramos413

Yes, that worked perfectly! Thank you so much!

Paul Newcome

I would suggest creating a row report pulling from the sheet that is grouped by service type then use the summary feature within the report to get your totals which can then be used for your chart.

Saves from having to use formulas and separate sheets and whatnot.