Iferror sum

[mcgrath1980]

Hi

I'm new to the site and the world of excel

I'm looking for some help, I am looking to add the total in cell G:G

My problem is I only want the total if Row F has the letter B in it and row H has the letters CC in it.

I have tried the following :
Iferror(sumproduct((H:H:G:G=M16)*(F:F=L16)),0)

I done this way to pull the text I was looking for into a separate cell thinking it would be easier to get my result.

Any help would be great thanks

 

[Special-K99]

=SUMIFS(G1:G1000,F1:F1000,"B",H1:H1000,"CC"))

Dont use whole columns like G:G, limit the number of rows or you will get a slow response.

You shouldn't need IFERROR() unless your ranges have errors in them

 

[Phuoc]

Try:

=SUMPRODUCT(G:G,(F:F=L16)*(H:H=M16))

or:

=SUMIFS(G:G,F:F,L16,H:H,M16)

 

[mcgrath1980]

Thanks very much for your help both work great.