sumif function

Hi I have the below function =SUMIF(D8:D38, "Client sales**", C8:C38) However I would also like to include "trader related" as in SUMIF applies if D8:D38 reads "Client sales**" OR if it reads "trader related" Can anyone help? Thanks in advance S

<tbody> A B C D 1 Job# Description PO Type 2 3 5400 311 11st job 4 1101 NC Ward 350.00 deck 5 1102 IL Cotr flex 6 1101 NC Ward 350.00 deck 7 5204 600 Pat Place job 8 1102 IL Cotr 407.00 deck 9 1103 WA Brown flex 10 11...

I have a SUMIF that is pulling a 10 digit number (6100089103) there are 4 of these numbers that are very similar, replace the last number with 4, 5 and 6. My SumIF is Summing all 4 numbers even though they are not the full number I'm wanting it to pull. Here is my formula: This is a...

Any help would be appreciated, trying to use an indirect with a sumif formula. Here is the sheet: <colgroup><col style="width: 104px"><col width="64"><col width="64"><col width="71"><col width="43"><col width="31"><col width="34"><col width="29"><col width="46"><col width="70"><col...

Good mornign to all, I am trying to sum the last 6 rows in a continuously growing table when a specific name in a different column (letters column) is met. In the below example I would like to sum lets say the last 2 entries when the letter in the first column is C. I can get the last 6...

I have a sheet that is a master billing for 4 properties. The sumif is used to create a subtotal for each column with a row for each property. in column B user puts in a property code that is the constant in a sumif. Is there a way to do this with out sumif. The issue I am having is that it...

What does this formula mean? I've learned how to doSumIf functions from a tutorial vide online but i don't understand what i'm supposed to do for this =SUMIF('$data'!$A:$A,$A12,'$data'!E:E) usually sum If functions are in the form: SUMIF (range,criteria, [sum_range]) thanks for your time...

Hey guys, Just looking for a quick bit of help. Looking to use averageif for two conditions. Normally I'd use the averageifs formula, but, it's not two conditions on one value it's one value where it can be A or B. I've even tried the OR function with no success... So, what I've tried to do...