THIS IS AN EASY QUESTION

[Guest]

A B C
1 PAID? INT
2 175 N
3 175 B
4 175 B
5 175 N
6 175 B
7 175 N
8 175 B
9 175 N
10 175 N
11 175 N

HI
IN EXCEL COULD YOU PLEASE TELL ME WHAT THE FORMULA WOULD BE TO GET THE
FOLLOWING SUM?

I WANT TO GET A TOTAL BY ADDING ALL OF THE 175'S OF B ONLY
AND THEN I WANT A TOTAL OF N BY ADDING N'S 175'S ONLY

THANK YOU FOR YOUR HELP
Oside

 

[JulieD]

Hi

one way
=COUNTIF(B1:B11,"N")*175
or
=SUMPRODUCT((B1:B11="N")*(A1:A11))
or
=SUMPRODUCT((B1:B11="N")*(A1:A11=175)*(A1:A11))

Cheers
JulieD

 

[OZDOC1050]

=SUMIF(B1:B11,"B",A1:A11)
R
PETE

 

[Frank Kabel]

Hi
use COUNTIF / SUMIF. e.g.
=SUMIF(B:B,"B",A:A)
and
=SUMIF(B:B,"N",A:A)

Note: please turn-off your CAPS Lock: difficult to read and considered
as shouting in NGs

 

[Jonathan TAylor]

USE A PIVOT TABLE IT IS MUCH CLEARER. AND THEY LOOK
GREAT!!!. JUST GO TO DATA/ PIVOT TABLE IT WILL GUIDE YOU
THROUGH THE STEPS