one number from 2 type of criteria

[gregg24]

I want a total count of a numbers, from a range of numbers. Though I have 2 types of criteria I want to apply to get that number. I have tried many different ways but cannot get it to work. Does anyone have any ideas?

 

[VoG]

Try posting an example with a clear description of what you want to do and the result that you expect. You can use Excel Jeanie for that http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[gregg24]

In column E there is “1AC”.
In column Y there is “APR”
In column V there is a range of 13 numbers that total $39,558.39
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I now just use a filter in the columns E and Y. Then use the sum function to get the total number. I am looking for a formula that will do just that.
<o> </o>
I have tried several different formulas but could not get them to work. Any ideas?