Relating SUM COUNTIFS to specific cells

[DiscoJean]

Hi,

I have a spreadsheet in which we want to be able to log and track data quickly and easily.

I have managed to get all formulae working, but was wondering if it is possible to relate my SUM COUNTIFS formuale to specific cells.

E.g. Cells B3 to G3 will have the values that I want the SUM COUNTIFS to use. These values are currently saved as 0 as I have to type them in and then copy the formula down, which adds time which is a very valuable commodity in my company.

My formula is:

=SUM(COUNTIFS(B7:G25,{0,0,0,0,0,0}))

And it is the {0,0,0,0,0,0} section that I want to read {B3,C3,D3,E3,F3,G3} but I am currently not able to enter a cell reference.

Cells B3:G3 will only have numerical values 1 through 27.

The COUNTIFS range will always have numerical values 1 through 27.

Any help, will be most appreciated.

Thanks!

 

[sheetspread]

Try

=SUM(COUNTIFS(B7:G25,B3:G3))

ctrl-shift-enter

 

[Marcelo Branco]

Try

=SUMPRODUCT(COUNTIF(B7:G25,B3:G3))

M.

 

[DiscoJean]

Thanks!!!

The =SUMPRODUCT(COUNTIF(B7:G25,B3:G3)) worked perfectly.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.