Spreadsheet Math Programming

**moosedaddi** · 09-14-2011, 12:59 PM

Hey folks,

I have a column of Labels, then a column of integers.

Im trying to do mathematics on certain integers that have a particular word in the labels. Is there any if check or function I can set to search for that string and run the math function?

Thanks in advance

**Mordred** · 09-14-2011, 01:26 PM

When you say you have a column of labels, do yo mean that you have multiple ActiveX labels or are the labels just cells filled with text?

**moosedaddi** · 09-14-2011, 01:35 PM

Labels are just cells filled with text.. no ActiveX api

**Mordred** · 09-14-2011, 01:37 PM

Can you upload a mock workbook with non-sensitive data in it? If you do that someone here should be able to help you without any problem.

**royUK** · 09-14-2011, 01:40 PM

Possibly:

SUMIF
SUMIFS
PIVOTTABLE

**moosedaddi** · 09-14-2011, 01:45 PM

Yes most definitely. A mockup is attached.

Basically the math being done in F15 is what I want done to any label that has "Overtime Hourly Rate 1." What Im ultimately doing is getting that label and getting a 33% out of it subtracting from the total ( D13 ).

**moosedaddi** · 09-14-2011, 01:56 PM

Originally Posted by royUK

Possibly:

SUMIF
SUMIFS
PIVOTTABLE

I tried the SUMIF, but it's criteria parameters ask for integers, no strings. SUMIFS is same thing but 2 conditions. For PIVOTTABLE, only thing I saw that would be close was the count function, but that only counts the cells. I gotta somehow do math on one particular label, over and over. I just found myself doing tedious work searching and selecting the cells that had the label..