I'm trying to sum certain entries in a column by a reference letter in
another column. For instance trying to get a total of all the "A" entries all
the "B" entries, and so on, in a single cell?? Please Help...??
I'm trying to sum certain entries in a column by a reference letter in
another column. For instance trying to get a total of all the "A" entries all
the "B" entries, and so on, in a single cell?? Please Help...??
Hi
Have a look at SUMIF(). There are other alternatives but that is the
simplest - if it does what you want.
Andy.
"Phil" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to sum certain entries in a column by a reference letter in
> another column. For instance trying to get a total of all the "A" entries
> all
> the "B" entries, and so on, in a single cell?? Please Help...??
If you have lots of different "entries", then you might want to consider the
Data > SubTotals feature..........
Vaya con Dios,
Chuck, CABGx3
"Phil" wrote:
> I'm trying to sum certain entries in a column by a reference letter in
> another column. For instance trying to get a total of all the "A" entries all
> the "B" entries, and so on, in a single cell?? Please Help...??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks