Trying To Use Formulas To Add Numbers with Only 2/3 Sets of Criteria

[oldeirish]

I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both HP and Q1.

As well as getting the data with these two columns, how would I add in another data variable, such as adding in each rep for each Quarter to be in my Pivot Table.
I’m so frustrated, I can’t think properly, as it’s been days …. J
I’ve tried VLOOKUP, HLOOKUP, IF, AND, IFERROR, COUNTIF ….etc
I understand if I didn’t do it correctly, it wouldn’t work anyway, so any assistance would be oh so appreciated.
I’ve inserted the Data_Table, Pivot Table and the smaller tables as well.

https://onedrive.live.com/redir?resid=6D8B65C0B80C0492%2123074


All this data in the table will be in a Pivot Table

Thank you kindly

 

[oldeirish]

https://onedrive.live.com/redir?resid=6D8B65C0B80C0492%2123074

This is link to use

 

[mikerickson]

Did you try COUNTIFS or SUMIFS (note the final S)

 

[oldeirish]

Hi,
Thanks for your reply. I have tried those, but I’m thinking I completely messed it up somehow. I’ll try again. Do you have an example?
Thanks again!

 

[velkugan]

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"] [/TD]
[TD="width: 64"]Q1[/TD]
[TD="width: 64"]Q2[/TD]
[/TR]
[TR]
[TD]HP[/TD]
[TD="align: right"]65633.45[/TD]
[TD="align: right"]153154.4[/TD]
[/TR]
[TR]
[TD]Conf[/TD]
[TD="align: right"]16840.8[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Quote[/TD]
[TD="align: right"]13673.5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]LP[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]107709.6


[/TD]
[/TR]
</tbody>[/TABLE]

=SUMIFS($G$4:$G$20,$F$4:$F$20,$K5,$H$4:$H$20,L$4)

Try this

 

[oldeirish]

Hi,
That formula worked great, just need to fine tune it …wonderful!!! Days of pulling my hair out are almost over!
Thanks you for taking the time mikerickson!
I’m also going to try the formula posted from velkugan.
Again, thank you both..