I would like excel to find numbers in a range of cells. and then gather data from cells in the same row and add them up.

e.g.
cells b1 through b 15 contain a number example 1 2 3 2 5 3 4 2 6 3 4 1

cells c1 through c15 contain a currency number 2.45, 4.36, 3,21, 4.34 8.62 so forth and so on.

I need a function the takes the number in b1 through b 15 snd then look at the info in c1 through c15 and add the numbers in c1 through c15 for each corresponding cell in b1 through b15

b2 = 2and c2 = 4.36
b4 = 2 and c4 = 4.34

the output in another cell should be 8.70



is this possible?
sorry its so long but the best way to describe it, I tried...

=sumif(b1:b15,2,c1:c15)

Perfect. Thanks many times over

I am wanting to take this across 2 columns e1 to f 25> it doesn't return anything when I do this. is this possible?

If you want to sum values in G1:G25 where E1:E25 and F1:F25 = 2 then:

=SUMIFS(G1:G25,E1:E25,2,F1:F25,2) or

=SUMPRODUCT((E1:E25=2)*(F1:F25=2)*(G1:G25))

Instead of hard coding 2 in the formulas you can of course refer to a cell and then put 2 or another number in that cell.

A1 B1 C1 D1
25.00 0.00 CASH 72.00
32.00 0.00 CASH
00 15.00 CASH

column a is one departments account
column b is another departments account
column c is the method of payment
and I would like column d to add only cash payments but ONLY in one cell. There will be other forms of payments but I would like excel to only find cash payments.
the other 2 (after editing to my actual cells) produced a zero. and I did put quotes around the CASH

Thanks in advance

Maybe like the attached.

Attached Files

Cash_Payments.xlsx (10.8 KB, 9 views)

See the attached in the second page or book. Thanks.

Attached Files

Cash_Payments.xlsx (13.1 KB, 10 views)

Still another trial.

Attached Files

Cash_Payments_2.xlsx (14.3 KB, 10 views)

That Works. I did want across 2 columns, but I can adjust my input to eliminate that. I had something similar to that I just didn't have the dollar signs. AND I never would have figure that out. This is the best forum ever. I hope my challenges are not to tiring. Thanks so much

Across two columns (even if I don't understand the rationale).

Attached Files

Cash_Payments_3.xlsx (14.7 KB, 8 views)

Thank you. I appreciate your help. Sometimes I don't get the cash payment in the same fiscal time period and have to carry it over to another time period. So I would have billed and collected and billed not collected and the next period collected but already billed. Like accounts receivable. Your help is very appreciated