Need Formula

[LNIX]

I need a cell formula for taking specific information from
one worksheet columns and combine into a seperate
worksheet..

Example= I need formula for all "A"'s in Colum D get a
total count on all Column G numbers belonging to "A"'s

Column Column
D G
"Type" "M per"
D 3
A 4
C 2
D 5
B 2
B 8
A 12

Thx

 

[Kevin Stecyk]

Hi,

I think this is what you are looking for....

=sumif(Col_D, "A", Col_G)

This sums all the "A" values in Col G.

Hope that helps.

Regards,
Kevin

 

[Don Guillett]

I think, instead of count, you meant sum of col G where col D had A
=SUMPRODUCT((d1:d4="a")*g1:g4)

 

[Kevin Stecyk]

Don,

Thank you for the correction.

I tend to use an array formula when doing this type of problem, but I
thought I would use sumproduct to answer the question and I goofed.

I tend to use something like...

{=SUM(IF(Col_D="A", Col_G))}

I will have to be more vigilant when using Sumproduct to ensure that I have
the correct formula.

Regards,
Kevin

 

[Don Guillett]

Been there, done that. I just prefer sumproduct for anything where it will
work.