THIS IS AN EASY QUESTION

O

Oside

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
 
J

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
 
F

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
 
J

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
 
Top