Help building a formula for a series of data

[Hadiya]

I have data in a series of columns and I need help to build a formula which helps me sum a series of data if conditions in two of the columns are met. For example, in the attached file I want to say if the data in column A (product) is Visa Classic and the data in column C (transaction) is Purchases-On Us then sum the data in column D (count). I can do a nested IF AND statement if it is single data but I can't figure out how to do it when it is a series of data. So the end result for the scenario I provided above should be 127.

Can you assist?

Thanks

Hadiya

[azumi]

Consider your criteria "Visa Classic" in cell F3 and Purchase-On Us in cell G3, put this formula on F5 :

=SUMIFS(D2:D12,A2:A12,F3,C2:C12,G3)

or

=SUMPRODUCT(--(A2:A12=F3),--(C2:C12=G3),D2:D12)

[Hadiya]

Hi,

Thanks for the reply. However, if there a way that I can use words in the formula? E.g.
If cells in range A2:A12=Visa Classic and cells in range C2:C12=Purchases-On Us then return the sum of cells in range D2:D12.

The data set I have to use is very large so making a cell for each of the different types of transactions would be very large.

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )