better formula needed

  • Thread starter Thread starter Dave W
  • Start date Start date
D

Dave W

I have a worksheet with 7 columns, col. "a" thru col. "g"

I have 35 rows of data

the first 2 columns contain text data, all the other
columns contain prices or numbers.

I would like to have columns 3 thru 7 subtotal depending
on what column "a" has in it.

if any row in col "a" contains the word "Base" then show
the column subtotals in col 3, col 4, col 5 .. etc.

If this scenario is not clear, I will try to clarify

Please help steer me in the right direction!

I would prefer not to use the auto filter in this case.
 
=SUMIF($A$1:$A$500,"*Base*",B1:B500)

put the formula in column B and copy across for the rest of the columns

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Sorry, change the references from B to C in my formula and copy across,
I didn't see that you have 2 columns with text

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Thank you for your help. I was having trouble with the
wild card aspect of the formula.
 
Back
Top